Jump to cell address

[TazShaik]

Hi,

Suppose there are 1 - 20 values in Sheet1 A1 : A20,

On Sheet2, My cell cursur is on A1, refering to Sheet1!A1. So, when
drag the Fill Handle in Sheet2, it should display the values o
Sheet1!A5 in Sheet2 A2. Then in Sheet2 A3, it should display the valu
of Sheet1!A10 when dragged further and so on.

Can anybody help me with this

 

[Bob Phillips]

In a2: =INDIRECT("Sheet1!A"&(ROW()-1)*5)

the copy down


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)