I have a row of data, A1, B1, C1 ...... ( 100 data)
I have a row in a different worksheet. The formula used to generate the data in this row should look like this:
Sheets("sheet2").A1 = Sheets("sheet1").A1+1
Sheets("sheet2").B1 = Sheets("sheet1").E1+1
Sheets("sheet2").C1 = Sheets("sheet1").J1+1
.....
Basically choose one data from every five cells for the calculation
I am trying to write a formula in the sheet2 A1, and then just drag the fill handle on the right bottom corner of the cell A1 to copy over to other cells on the right. Does anybody know what formula I should use?
Thanks for the help
dlee
I have a row in a different worksheet. The formula used to generate the data in this row should look like this:
Sheets("sheet2").A1 = Sheets("sheet1").A1+1
Sheets("sheet2").B1 = Sheets("sheet1").E1+1
Sheets("sheet2").C1 = Sheets("sheet1").J1+1
.....
Basically choose one data from every five cells for the calculation
I am trying to write a formula in the sheet2 A1, and then just drag the fill handle on the right bottom corner of the cell A1 to copy over to other cells on the right. Does anybody know what formula I should use?
Thanks for the help
dlee