Captain Smith
Active Member
- Joined
- Feb 28, 2003
- Messages
- 324
Is there a formula to return the sheet number? What I want to do is have a formula that always references a cell in the sheet to the immediate left. The first sheet of course would not reference. So if I have the formula in Sheet 3 the formula would automatically reference the cell in Sheet 2. I want the user to just be able to make a copy of the sheet so that the copied sheet would have the correct formula reference. I want to avoid VBA.
Thank you.
Thank you.