Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Hey Noorain, it's perfectly working On Thu, Aug 25, 2011 at 3:43 PM, NOORAIN ANSARI wrote: > Dear Frederic, > > This function LOOKUP(9^9,A:A) is not working.. > We are unable to find Adject Output, it is showing #N/A error.. > -- > Thanks & regards, > Noorain Ansari > *http://noorain

Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Huh :| Don't you have any problem with your data (like text instead of figure) on the last position ? It works perfectly on my computer On 25 août, 12:13, NOORAIN ANSARI wrote: > Dear Frederic, > > This function LOOKUP(9^9,A:A) is not working.. > We are unable to find Adject Output, i

Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Dear Frederic, This function LOOKUP(9^9,A:A) is not working.. We are unable to find Adject Output, it is showing #N/A error.. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Thu, Aug 25, 2011 at 2:36 PM, Frederic LE

$$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Use the function LOOKUP(9^9,A:A) 9^9 = 387420489 Because this value is not in your range A:A, Excel return the last value of your range. Then, you copy/paste this formula 40 times and you just have to change the column's reference. And if the hearder of your report worksheet is equal to the works

$$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Clint Have you thought about using formulas for your summary sheet? That way you won't need to copy to a summary sheet, repeat the process, and then delete it the following day. The formula will keep your summary sheet constantly updated. You would need to set it up to begin with, but after tha