685villa
New Member
- Joined
- Jul 8, 2022
- Messages
- 8
- Office Version
- 365
- 2021
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
The envision of a one-stop-shop tracker I have has one single master sheet, 'tableA' for all other sheets to reference.
On every other sheet, I want only the first 3 columns the same, but the rest of the info in each table and each column name, to be different to show the respective info on the subsequent rows/columns of the other sheets.
'tableA's first 3 columns would only need to be on the other sheets (40+) yet each other individual sheet would need to be able to be filtered by the first 3 columns.
Would this be a case of each separate sheet only having a query to the 3 (only?) first columns and a separate table on each respective sheet? If so, how then would I be able to filter the data from the first 3 columns on each sheet to correspond to the other columns & rows and the other sheets?
Thanks!
-V
On every other sheet, I want only the first 3 columns the same, but the rest of the info in each table and each column name, to be different to show the respective info on the subsequent rows/columns of the other sheets.
'tableA's first 3 columns would only need to be on the other sheets (40+) yet each other individual sheet would need to be able to be filtered by the first 3 columns.
Would this be a case of each separate sheet only having a query to the 3 (only?) first columns and a separate table on each respective sheet? If so, how then would I be able to filter the data from the first 3 columns on each sheet to correspond to the other columns & rows and the other sheets?
Thanks!
-V