Formula using one out of five cells from the other row

D

dlee888

Joined
Jul 20, 2007
Messages
8
Reaction score
0
Hi,

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
 

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

Worksheet functions using one out of every five cells 0
Formula Needed!!! 0
Formula for drag and copy and paste 0
Formula for drag and copy 0
copy/paste in the next column 4
Copy range from one sheet to another cell by cell 2
Excel VBA help: Text file formatting 19
Copy contiguous from one sheet and paste to another every other ro 1

Top