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
Hello dsamglick,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
This is not the right place to ask that question David
Hello David and Welcome to Excel Forum.
As gerygg states questions should be placed in one of the Microsoft Office Application Help - Excel Help forums linked below.
https://www.excelforum.com/microsoft...el-help-forum/
My feeling is that your issue may be solved by using Power Query (Get & Transform) which would best match the Excel General forum.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks