shekel balanon
New Member
- Joined
- Jul 27, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I am a newbie here.
May I ask for your help? How do I automatically change the sheet reference but not the formula?
The formula I'm using is =SUM('1'!C8:C35).
And when I drag it downwards, I want the sheet reference to become '2'
I am a newbie here.
May I ask for your help? How do I automatically change the sheet reference but not the formula?
The formula I'm using is =SUM('1'!C8:C35).
And when I drag it downwards, I want the sheet reference to become '2'