redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
In Sheet 'Summary' I have this simple formula in cell B2
how can this be slightly changed so that it will automatically change when copied to cell B3 to take the value from sheet2 cell K2, then also change when added to B4 so that it takes the cell value of K2 in sheet3 etc etc
so to end up with the following formula in each cell...
B2 ='1'!$K$2
B3 ='2'!$K$2
B3 ='3'!$K$2
B4 ='4'!$K$2
etc etc
thanks in advance
Code:
='1'!$K$2
how can this be slightly changed so that it will automatically change when copied to cell B3 to take the value from sheet2 cell K2, then also change when added to B4 so that it takes the cell value of K2 in sheet3 etc etc
so to end up with the following formula in each cell...
B2 ='1'!$K$2
B3 ='2'!$K$2
B3 ='3'!$K$2
B4 ='4'!$K$2
etc etc
thanks in advance