Copying cells

A

ajohns

Hi

I would like to copy the contents of every 10th cell in a row in a
contineous column on a separate sheet. Is there a quick way of writing
the address that allows you to drag down and add a value of 10 to the
cell address?

Many thanks

Yours

Andrew J
Scotland
 
F

Frank Kabel

Hi Andrew
one way:
=INDEX('Sheet 1'!$1:$1,1,1+(ROW()-1)*10)
copy down. This will get you the 1st, 11th, 21st,... column in Row 1

HTH
Frank
 
Top