$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks
Dear Mandeep, This is fabulous!! unbelievable many thanksYou saved 5 days for me... :) regards On Thursday, 11 February 2016 11:37:20 UTC+4, zaks wrote: > > Is there any way to copy data from different sheets and place it in 1 > summary sheet (200+ worksheets in 1 excel file) &g

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks
Oops...forgot to attach it.. here it is... On Thursday, 11 February 2016 13:48:35 UTC+4, Mandeep Baluja wrote: > > Where are sample files ?? :( >> >> -- 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 @

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks
sday, 11 February 2016 13:21:01 UTC+4, Mandeep Baluja wrote: > > zaks Every thing is possible Except my increment :P !! Elaborate what you > wish to combine from Every sheet. > @ Devendra :Same process, but for workbooks you need to loop files in > folder one by one and Consolidate

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks
Dear Mandeep, Thank you so much, it did work very well.. but my question was incomplete. I need only few data from each sheet to be copied to 1 summary sheet. Is that also possible.. On Thursday, 11 February 2016 11:37:20 UTC+4, zaks wrote: > > Is there any way to copy data from dif

$$Excel-Macros$$ Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-10 Thread zaks
Is there any way to copy data from different sheets and place it in 1 summary sheet (200+ worksheets in 1 excel file) will be great help if anyone has an answer regards -- 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 Facebo