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

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 it !! *Regards, * *Mandeep baluja *

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

Hi Mandeep, If we have multiple files, then how can we make a consolidated sheet using a macro ? Thanks, On Thu, Feb 11, 2016 at 2:09 PM, Mandeep Baluja wrote: > Worksheets Combine !! Run this macro Hope you're aware about how to run a >> macro !! if not try this >>

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

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 different

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

Dear Mandeep... Can understand...& hopefully u will get one soon! I have attached a sample file with 5 sheets, where 1st sheet is what i am looking to get from the original 200+ sheets in my workbook. Data is linked for ur understanding... thanks again for the troubleCheers! On

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

> > Worksheets Combine !! Run this macro Hope you're aware about how to run a > macro !! if not try this > > https://support.office.com/en-us/article/Run-a-macro-5e855fd2-02d1-45f5-90a3-50e645fe3155 Sub Simple_Combine() Application.ScreenUpdating = False Application.DisplayAlerts = False

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

Simple use this formula after pressing the button, Without any hassle ,Clear sheet after doing work. > > Regards, Mandeep baluja -- 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)

> > Haha !! Glad to Help Bro :P,Thanks for providing the references otherwise >> it will be cumbersome to look values !! >> > Regards, Mandeep baluja https://www.linkedin.com/messaging/thread/6086488646137958400 https://www.linkedin.com/in/mandeep-baluja-b777bb88?trk=hp-identity-name

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

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)

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) > > will be