Auto collect all data from multiple sheet to one master sheet
Hi,
Can you help me on this.
I have 6 sheets of data (Jan to June). I need to update all data automatically into one master sheet (may be using button click)
Please refer my attachment for your understanding.
Thanks in Advance. It will be great help.
SK
Try this macro
Please Login or Register to view this content.
Open up the VBA editor by hitting ALT F11
Insert a new module by hitting Insert - Module
Paste the macro into the empty sheet
Hit ALT F11 to get back to the worksheet.
Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.
Martin
Try (you might need to make some adjustment to make the month entry as I am kinda lazy to do it right now, but the macro consolidates all the data into the summary sheet)
Please Login or Register to view this content.
Re: Auto collect all data from multiple sheet to one master sheet
Thank you so much. It works great.
Originally Posted by mrice
Try this macro
Please Login or Register to view this content.
Open up the VBA editor by hitting ALT F11
Insert a new module by hitting Insert - Module
Paste the macro into the empty sheet
Hit ALT F11 to get back to the worksheet.
Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.
Hi,
One more query. I have VisitorEntrySheet which is not be displayed in TotalSummary Sheet. How can I stop fetching data from that particular Sheet(s) - Now its catching all the data even if i created new sheet front or back (any where).Thank you
Last edited by skhari; 05-12-2012 at 11:48 PM.
Try
Please Login or Register to view this content.
Thanks. That helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks