In A1 of sheet B enter =INDIRECT("A!B"&ROW(A1)*6)
Copy this down the column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"FishHead" wrote in message
...
Is there a way to write a command that will transfer the value of every
"6th"
cell of a column in worksheet "A" to a contiguous column of cells in
worksheet "B"? For example the value in "A!B6" is transferred to "B!A1",
"A!B12 to B!A2", "A!B18 to B!A3" etc. etc. I know I can manually
reference
each target cell in Worksheet A to transfer over to Worksheet B, but the
scope of this project is such that I would like to write a
function/command
that can then be copied and pasted. A normal copy and paste is dynamic
one
row at a time and I need it to reference every 6th row.

Sorry for the "less than eloquent" description of my problem.