Hi
I am completely new to working with visual basic and have tried to create some code but with very little success. I am trying to create a summary sheet which will collate data from multiple workbooks contained within the same file. The summary sheet needs to collate cells B42 to H63 (constant) of each worksheet - example attached.
Any help would be greatly appreciated
Regards
stuart
Do you mean multiple tabs of the same workbook or multiple workbooks in the same folder?I am trying to create a summary sheet which will collate data from multiple workbooks contained within the same file.
Should the data be collated in a new workbook?
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]
Hi
Ideally multiple workbooks in the same folder collated into a new workbook. Basically each room will be a workbook with the equipment of each (cellsB42 to H63) summarised into a separate workbook.
Cheers
stuart
Will the multiple workbooks have data in more than 1 sheet?
Hi Arlette
All the workbooks will have just 1 sheet as the template to fill in. This is the sheet i attached originally.
thanks
stuart
Use this code in a blank workbook. The data will be consolidated in this workbook. You can probably have a button that triggers this macro to run.
Please Login or Register to view this content.
Thanks Arlette that works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks