Forum Discussion
Build Workbook automatically from several files
Is it possible to build a workbook with formulas to add sheets from several files. I have to build reports for work and each one is unique but with the same files, just different amount of each file. I would like to have a sheet that I can Identify how many copies of each file to add as a sheet from the number of copies entered. Don't know if this is possible. Example below. Thanks in advance.
| File | Number of sheets add to workbook |
| Piston Rod | 6 |
| Con Rod | 3 |
| Crosshead | 2 |
1 Reply
I am viewer #50 of your post. No replies till now. I strongly suspect it's because nobody understands exactly what it is you're trying to do and why. You make clear that you have to come up with some reports, reports based on data drawn from multiple files, but beyond that what you've described calls for many questions.
So could you anticipate what some of those questions might be and give some answers. Here are some starters:
- What's the nature of the data on those various files needing to be collated/combined/collected?
- Is it the whole of each sheet, or simply some specific data from each sheet?
- Is this a one-time report, or a regularly required report?
- If the latter, are you (or your organization) open to re-thinking the whole process?
Again: those were just for starters; the basic idea is that you'll need to provide a lot more information about the big picture here, as well as the details before meaningful help can be offered.
