mattyj7183
New Member
- Joined
- Dec 28, 2015
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
This one is starting to hurt my brain.
I have a workbook with multiple sheets and the point of the book as a template for a questioner/form. Each tab has various items to fill out or answer. Some basic info, some with dropdowns, and some referenced via formulas. Each client will have their own workbook, with their own data, which will result in about 800 individual files. The initial plan was to keep these workbooks separate, but it now seems that forming a database out of all the data points spread throughout the different tabs is worth pursuing. Generally, the same data points are in the same cells across the multiple workbooks (ie A2 of every "Client Profile" sheet contains the group name, A8=primary contact, A9=secondary) but there are cases where the data might not be in the same exact cell. In my "Cash Management" sheet I have a list of accounts with various details and not every client has the same number of accounts.
I was experimenting with the Query feature and I was getting stumped then I tried messing around with the name manager and that didn't work either. Ideally, I would like to have one master sheet that has all the headings of what I would like to pull from the other sub-workbooks. As the title says, I am essentially reverse engineering a database.
Is this possible?
I have a workbook with multiple sheets and the point of the book as a template for a questioner/form. Each tab has various items to fill out or answer. Some basic info, some with dropdowns, and some referenced via formulas. Each client will have their own workbook, with their own data, which will result in about 800 individual files. The initial plan was to keep these workbooks separate, but it now seems that forming a database out of all the data points spread throughout the different tabs is worth pursuing. Generally, the same data points are in the same cells across the multiple workbooks (ie A2 of every "Client Profile" sheet contains the group name, A8=primary contact, A9=secondary) but there are cases where the data might not be in the same exact cell. In my "Cash Management" sheet I have a list of accounts with various details and not every client has the same number of accounts.
I was experimenting with the Query feature and I was getting stumped then I tried messing around with the name manager and that didn't work either. Ideally, I would like to have one master sheet that has all the headings of what I would like to pull from the other sub-workbooks. As the title says, I am essentially reverse engineering a database.
Is this possible?