ecoleman42us
New Member
- Joined
- Mar 10, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a formula that references sheet names. I can create the formula that goes into the same cell on each sheet. When I copy and paste the formula the sheet will not automatically up date. Is there way of doing this? I created a separate sheet and listed the names of all the other sheets being used thinking I could use an indirect formula but again when I copy and paste the sheet name did not update. The sheet names are in sequence 1st,2nd,3rd.....