Copying cell references
Posted by Wilma on December 02, 2001 10:40 PM
Can someone please help?
I have a workbook containing a few worksheets.
The main worksheet (W1) contains a summary of the other worksheets. The information on W1 is organised horizontally. The other worksheet (W2) is organised vertically.
The problem is that when I tried and reference a range of cells in W1 to W2 it doesnt work properly. EG.
If I had a range of cells in W2 E7 - E49 I then go to W1 and put in the following =W2!$E7 and attempt to drag the crossbar horizontally so that the E will stay the same and the row number will increment. It doesnt. It will copy E7 into all of the cells.
What am I doing wrong?