acarter12078
New Member
- Joined
- Apr 2, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Hi.
I have a summary sheet that is bringing in values from 131 different worksheets.
At the moment the few totals I have are referenced manually by typing in the sheet reference in the formula.
=HBH!$G$41 (sheet name HBH and the total is in cell G41)
In my summary page I have the sheet reference listed (in this case its cell C10)
I can't seem to get a sheet reference to work in the formula.
In total I need to bring across 700+ references so don't want to do it manually.
any help would be appreciated.
thanks
adam
I have a summary sheet that is bringing in values from 131 different worksheets.
At the moment the few totals I have are referenced manually by typing in the sheet reference in the formula.
=HBH!$G$41 (sheet name HBH and the total is in cell G41)
In my summary page I have the sheet reference listed (in this case its cell C10)
I can't seem to get a sheet reference to work in the formula.
In total I need to bring across 700+ references so don't want to do it manually.
any help would be appreciated.
thanks
adam