ExcelBanter - Excel 2003: Replicating Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2003: Replicating Formula (https://www.excelbanter.com/excel-worksheet-functions/182594-excel-2003-replicating-formula.html)

ocean mist

Excel 2003: Replicating Formula

I have a summary sheet that references cells in another worksheet. The cells
that are referenced are not consecutive. e.g.

Weekly Summary Sheet
V3 ='3-14-08'!B8
V4 ='3-14-08'!B11
V5 ='3-14-08'!B19
etc.

As you can see, the formula references the 3/14/08 worksheet. Now I want to
reference the 3/21 worksheet but keep the cell numbers, B8, B11 and B19 the
same. How do I do that?

AKphidelt

Excel 2003: Replicating Formula

Put $ signs around the B. So it will look like

V3 = '3-14-08'!$B$8
V4 = '3-14-08!$B$11
etc

"ocean mist" wrote:

I have a summary sheet that references cells in another worksheet. The cells
that are referenced are not consecutive. e.g.

Weekly Summary Sheet
V3 ='3-14-08'!B8
V4 ='3-14-08'!B11
V5 ='3-14-08'!B19
etc.

As you can see, the formula references the 3/14/08 worksheet. Now I want to
reference the 3/21 worksheet but keep the cell numbers, B8, B11 and B19 the
same. How do I do that?

All times are GMT +1. The time now is 03:11 AM.