Copying groups of cells and incrementing a counter
Posted by Mohsin on September 19, 2001 12:56 PM
I have three rows in a worksheet that pick up values from another worksheet's columns.
row1 --> =mysheet!A2
row2 --> =mysheet!D2
row3 --> =mysheet!F2
I want to fill in the rest of my worksheet so that I can get something like the following.
row1 --> =mysheet!A2
row2 --> =mysheet!D2
row3 --> =mysheet!F2
row4 --> =mysheet!A3
row5 --> =mysheet!D3
row6 --> =mysheet!F3
row7 --> =mysheet!A4
row8 --> =mysheet!D4
row9 --> =mysheet!F4
....
Thanks