Hi
I need a macro to do the following
Have a workbbok with about 45 sheets named “1”,”2”,”3” etc till 45 , which are filled with data till column T
There is also a sheet named “ALL-INFO” which is empty (currently)
Would like to append the data from each sheet to this sheet (ALL-INFO) and put the sheet name from where the data came next to the data in column U
Hope somebody can help me
Thanks
David
I need a macro to do the following
Have a workbbok with about 45 sheets named “1”,”2”,”3” etc till 45 , which are filled with data till column T
There is also a sheet named “ALL-INFO” which is empty (currently)
Would like to append the data from each sheet to this sheet (ALL-INFO) and put the sheet name from where the data came next to the data in column U
Hope somebody can help me
Thanks
David