Formula for drag and copy

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").F1+1
Sheets("sheet2").C1 = Sheets("sheet1").K1+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 put in the "A1"?

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