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 ...
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.