jake.peterson
Board Regular
- Joined
- May 22, 2012
- Messages
- 68
I have multiple tabs names Rep1, Rep2, Rep3, etc.
On a summary sheet I have a cell set as =Rep1!D11
If I click on that and drag it down to fill series it goes to Rep1!D12, Rep1!D13 etc.
Is there a way to make it remain D12 and change to Rep2, Rep3, Rep4 etc?
I would like to change the relative reference to the sheet name instead of the cell.
On a summary sheet I have a cell set as =Rep1!D11
If I click on that and drag it down to fill series it goes to Rep1!D12, Rep1!D13 etc.
Is there a way to make it remain D12 and change to Rep2, Rep3, Rep4 etc?
I would like to change the relative reference to the sheet name instead of the cell.
