Formula for drag and copy and paste

Jul 20, 2007
Reaction score
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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question