Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
Hello folks,
I want to copy a range of cells (A1:AP165) 59 times. If that was all I wanted, then no problem. The issue I have is that cell A2 refers as follows: =Feeder!$A$2. When the range is copied for the first time, the reference needs to change to $A$3 and then $A$4 and so on.
I could change cell A2 to be =Feeder!A2 but how can I get the reference to increase by 1 on each copying of the range.
Many thanks for your help.
Mel
I want to copy a range of cells (A1:AP165) 59 times. If that was all I wanted, then no problem. The issue I have is that cell A2 refers as follows: =Feeder!$A$2. When the range is copied for the first time, the reference needs to change to $A$3 and then $A$4 and so on.
I could change cell A2 to be =Feeder!A2 but how can I get the reference to increase by 1 on each copying of the range.
Many thanks for your help.
Mel