emilybrush
New Member
- Joined
- Jan 31, 2024
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hi All,
I'm looking for a formula to pull data a one cell in another sheet into a table on our summary sheet. The sheet name is contained in row A, the sheet name will increase by 1 for each row in the table. E.g. A3 = CR1, A4 = CR2.
Is there a formula which I can use in my table which will pull across data from cell C6 in the corresponding sheet (as named in row A)?
Thank you!
I'm looking for a formula to pull data a one cell in another sheet into a table on our summary sheet. The sheet name is contained in row A, the sheet name will increase by 1 for each row in the table. E.g. A3 = CR1, A4 = CR2.
Is there a formula which I can use in my table which will pull across data from cell C6 in the corresponding sheet (as named in row A)?
Thank you!