Forum Discussion
Master workbook
Hi! I'm a bit of a beginner at Excel and have hit a wall here.
I'm a bit lost on how to tackle this, so I've come to ask for some advice.
I have A template workbook we use to store IMEI numbers of phones we use.
What I want to do is create a Master workbook where all the IMEI numbers will be present.
Most tutorials and guides I've found plays with the INDIRECT formula, but I kinda come to a halt with it, as they always use the formula to dynamically gather data from multiple WORKSHEETS, not WORKBOOKS.
The way I want this to work, (if at all possible), is so the Mastersheet dynamically updates with newly added WORKBOOK.
It's set up in a way so the workbook names just increase by +1
The first workbook with the IMEI number in is called 1.xlsx, second is called 2.xlsx and so on...
The cell in which the IMEI number is in does not change, the workbook name however does.
Any tips/ideas on how to forth about this?
Thanks in advance :)
- Why use a difficult to handle setup like this? It would be FAR easier to have one table with all details of all phones and then create a dynamic worksheet which nicely displays the details of one phone which you can select with a drop-down.
The reason is that we use the Workbooks for allot of different information too about the device, receiver etc...
It's set up in kind of a template way.
If there's no way to realistically do what I want though, I'll probably go with the way you proposed!
- You can easily retrieve all values of all files in a folder, provided they al have an identical layout. Use Data, New Query, From File, From Folder.
