1. How can i combine the multiple spreadsheet that is in my excel (which includes 4 of them) into a master list and it will be combined one after another. Meaning after Sheet1 last row will continue with Sheet2 first row and so on.
2. I also wish to have a automatic update in the master list spreadsheet when i make changes in the other spreadsheet.
I've been searching and trying for 2 days >< anyone please help?
Last edited by Grace14; 02-28-2012 at 12:05 PM.
Grace14, please attach a sample file with dummy data so we can assist you better.
Last edited by Mordred; 02-28-2012 at 05:48 AM.
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]
arlu1201,
This is the data I'm working on. Thank you so much ^^
Last edited by Grace14; 02-28-2012 at 08:33 PM.
You can use this code -
Please Login or Register to view this content.
Hi, Arlette.
Thank you so much!!!
Sorry that i never ask together. Is it possible to make it so that when i make changes in the spreadsheet then the master list will change accordingly?
^^
Actually to prevent it from being too complicated, the macro takes care of both your needs (1 & 2 in the first post). First, it will consolidate the data from all the tabs. 2nd - if you do make changes to any of the other tabs, just run the macro. It will clear the contents of the master sheet and consolidate again.Is it possible to make it so that when i make changes in the spreadsheet then the master list will change accordingly?
is it okay that i make it like button click? like using a command button?
Yes, just insert a button on the page and assign the macro to it.
Thank you Arlette. You really help me a lot ^^ thank you do much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks