Formula for drag and copy

D

dlee888

Joined
Jul 20, 2007
Messages
8
Reaction score
0
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
dlee
 

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

Similar Threads

Formula Needed!!! 0
Worksheet functions using one out of every five cells 0
add hyperlink using sheet names and cells(i,j) 3
Formula for drag and copy and paste 0
Formula using one out of five cells from the other row 0
Compare and copy/paste 1
comparing two sheets og copy value 8
Copy non merged to merged cells again 1

Top