I have 100 worksbooks, each containing the same sheet with formulas, tables etc.
Is there an easy way to import all workbooks into one MASTER workbook (but into separate sheets), so that the imported worksbooks are in sheet 1.. 100, preferably with the filename as sheet name?
I have looked at the Get Data feature, but it seems everything goes into one master sheet?
Last edited by Bartonsen; 06-08-2021 at 02:33 PM.
I'd not recommend having 100 sheets in a workbook. It's pain to navigate and get meaningful insight.
You should, combine data into single table with additional column for tracking source file name. Then load this to data model (or as table) then use slicer to control segmentation.
If that isn't an option, I'd recommend providing couple of sample source data (desensitized) to get better response.
Also, code and/or method will differ significantly on end result you need (i.e. do you need to retain formula or just the values etc).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Hi,
thanks for your feedback.
Unfortunately, the way it's been designed I think require a merge of the workbooks into 100 separate sheets. Last time I copied them one-by-one manually, but it's time-consuming, so I would really like a way to import them...
When they have been merged, there will be no need to navigate between them, because I will read out certain values into a main sheet. But I need the subsheets to be in the same doc.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks