Jump to cell address

T

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
 
B

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)
 

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

Automatically populating cells down a row 8
Formula fill series? 1
display a value from Sheet1-A1:A10 in Sheet2-B1 2
if statement, change cell only if true 4
Show formula result in another sheet 1
Duplicating cell values from one sheet to another 3
Referencing cells in consecutive rows 2
If function across sheets prints value of cell 4

Top