I have multiple workbooks in a common folder. I need to combine specific worksheets from each (score sheet) them into a master sheet with results. I.E. the header on the master sheet should only appear once. Would be great if automatic, but a button will work. Thanks for our help
This link may help.
Consolidate data in multiple worksheets
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks
The sheets are in different workbooks, though
This is from the first paragraph in the link...
To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks. When you consolidate data, you assemble data so that you can more easily update and aggregate as necessary.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks