eechristaylor
Board Regular
- Joined
- Oct 22, 2013
- Messages
- 51
- Office Version
- 365
- Platform
- Windows
I have a database of data across a large amount of columns. This data is looks similar to this:
I have a cell in a spreadsheet workbook with the same name as the 1st row and I want to grab the data in the second row using the workbook name. Is this possible? I don’t want to have to enter “Adams-1”, I want it to see that name in the workbook name and use that to grab the data.
Thanks
Adams-1 | Adams-2 | Adams-3 | Adams-4 | Adams-5 |
10 | 11 | 12 | 13 | 14 |
I have a cell in a spreadsheet workbook with the same name as the 1st row and I want to grab the data in the second row using the workbook name. Is this possible? I don’t want to have to enter “Adams-1”, I want it to see that name in the workbook name and use that to grab the data.
Thanks