Hi Shiv,
Please find attached solution..
i am using indirect function,
About Indirect Function
Returns the reference specified by a text string. References are
immediately evaluated to display their contents. Use INDIRECT when you want
to change the reference to a cell within a formula without c
Respected Experts,
Is it possible to create a pivot table taking data (or fields) from
different sheets of the workbook.
Regards,
P.VIJAY KUMAR
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Respected Prabhu,
Hope this file will be of little help to u.
Regards,
VIJAYKUMAR
On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky wrote:
> Hi all,
>
> I am very new to VBA working in MNC as a WFM specialist. we are working
> lots of reports on a monthly, weekly as well as daily basis.
>
> i cam
Thanks David and it's clear now.
Chris
On Fri, May 17, 2013 at 11:54 AM, David Grugeon wrote:
> Depends on the version. If you have 2010 or later you can use:
>
> Iferror(the formula,"")
>
> For earlier versions you use
>
> If(iserror(the formula),"",the formula)
>
> But both of these only work
Hi
Have this macro to take the
See code below. Comes up with compile error on the last row:
ActiveWorkbook..
Is it something to do in not having the sheet name ? If so it would have to
be taken from the tab. (I now see it is referenced as sht.)
or Is it something to do with the R1C1 re
Depends on the version. If you have 2010 or later you can use:
Iferror(the formula,"")
For earlier versions you use
If(iserror(the formula),"",the formula)
But both of these only work on the vl;ookup formulas. They will not work
in columns B, and H-L. For these you will need on row 7
If(A7=
David, thank you it worked perfectly, however, when I use the fill handle
to drag and fill down I ended up with 0, #NA and 0/01/1900 on the filled
row. How do I use IF(ISERROR ( function to get rid of 0, #NA and 0/01/1900??
Once again thanks for any help.
Chris
On Thu, May 16, 2013 at 4:26 PM,
Sorry premature send!
The code is
Public Sub MyConvertFormulas()
Dim oRange As Range
Dim c as Range
Set oRange = Selection
for each c in oRange
c.Formula = Application.ConvertFormula(Formula:=c.Formula, _
fromreferencestyle:=Application.ReferenceStyle,
toabsolute:=xlAbsolute)
Next c
The main issue is where the references point. If they are pointing within
the block you are copying, there is no issue as they will continue to point
to the appropriate cells within the block. If they are to another sheet
and the block is pasted in a different starting position (same or other
she
Dear Friend,
I feel that I am indebted for your kind words.
I always respect the TRUE suggestion / TRUE finding of others in a positive
manner,
because such things would only cause more interest to me on the subject.
IN REALITY, though I may develop more interest, the genuine deciding factor
Dear Friend,
First, I'd like to mention my thanks for your time and effort.
I need to mention a few words that
- after started reading a few messages
(which will be in line with my understanding level)
in this group, I could slowly realise the true power of
excel-macros-vba-codes.
- thus,
I'm certainly willing to help with your understanding.
If you have specific questions I'll attempt to explain it to your satisfaction!
I'm certainly not trying to discourage you.
At the same time, I don't want to spend a lot of time trying
to explain something you already know!
I'd rather spend th
If you look closely at the results, it returns exactly the same output
desired by you and if you take a look at the code, I am sure you can figure
out a way to replace 'E' with 'D'.
As Paul said, we are here to help, Sir and have absolutely no interest in
coding for requirements which keep escalat
Dear Friend,
At the outset, I thank you for your understanding.
I will certainly take an opportunity to learn the subject.
With Regards,
DK.
On Thu, May 16, 2013 at 10:11 PM, Paul Schreiner wrote:
> I understand completely...
>
> I was just trying to make sure you understand that there are SO
Fair enough.
The loop to look through the folders isn't easy to get to from the recorder.
If you look at the Help text for the SubFolders property, you'll see an example
of how to process subfolders.
This set of macros starts in the folder "C:\Temp"
and looks for the file: "Book1.xls".
It then
Thanks for the prompt paul,
But i tried few recording of macro, but didnt work. Can you please help me
with Sample Macro so that i can mobify that as per my requirement.
Regards
Pankaj k Pandey
On Thu, May 16, 2013 at 10:49 PM, Paul Schreiner wrote:
> How comfortable are you with VBA?
> How mu
How comfortable are you with VBA?
How much of this do you need help with?
The Filesystem object is used to set up the folder/subfolder navigation.
the function calls themselves are not difficult.
Do you then need help copying rows of data?
Paul
-
“Do all
dear champs,
any one provide the sub validations formula
enclosed the attachement.
--
Regards,
Shivaprasad K.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discus
I think you're going to run into SOME trouble
working with groups like this
They're intended to HELP users with problems,
not be a source of free programming.
Let's break down my explanation:
"You are currently testing your "response" variable
for vbYes and vbNo"
Your macro loops through all s
Dear Friend,
First, I'd like to mention my thanks for your time and effort on my request.
Now, I need to say that I do not have knowledge at all in VBA Codes.
(Honestly, due to lack of knowledge, I could not understand your valid
suggestion on my requirement).
If I come across something usefu
By what definition is a sheet "empty"?
Is there a cell that ALWAYS has a value, but if it is blank, then the sheet is
empty?
Is there a minimum number of rows in a sheet?
let's say: If Cell A1 is empty, then you want to move it to the end.
I would loop through the sheets, looking for the cell val
Hi, I have a spreadsheet with large areas of cells that do not have anchors
in the formuals. In other words, the content of a cell would for example
show =A1 instead of =$A$1
I need to copy this block of cells to a another location (not move, I
understand this works with cut/paste) where I w
You are currently testing your "response" variable
for vbYes and vbNo
If you simply add:
Else
Exit for
then, whenever neither the Yes button, or the No button is pressed
(like when you hit "Escape" or "cancel" the window)
then the loop will exit.
Paul
Dear Friend(s),
*SUB : IDENTIFY EMPTY SHEETS AND MOVE TO END.*
I have more than 50 sheets in a file.
I may not be aware, where the empty sheets are placed.
Hence, I look for the following :
1. Identify the Empty Sheet / Display the Empty Sheet with Msg Box.
2. Then, move
Dear Friend,
First, I'd like to mention my thanks for your response.
I may mention that I am a person of 40+, who looks without hesitation for
knowledge from all sources on my interested subjects like Word, Excel
(MACROS), PP, Access, Photoshop, etc.
Hence, I request you for :
- PAN restriction
I started recording and reading the code, it gives "static" code but it
gives a pretty good idea of how it works, for harder stuff, i'm escalating
with this forum, whenever I have doubts or stuff that I can't do, I ask for
help, and then read the code and try to understand it. For other stuff just
26 matches
Mail list logo
