Copying from another worksheet

[Wayne26el]

I have an excel worksheet which has a reference to another sheet (='Order
Numbers'!E448) I want to be able to replace the row number “448†with number
that I would put in. I would leave the column designation as is. How can I
accomplish this?
Wayne

 

[Patrick Molloy]

if this is a spreadsheet function then you could use

=INDIRECT("'Order Numbers'!E" & B3)
where Cell B3 has the row number, ie :=448

In VBA you could pass it as a parameter ...

DIM Cell As Range
DIM rownum As LONG
rownum = 448
SET Cell = Cells(rownum,"E")

 

[Gord Dibben]

=INDIRECT("'Order Numbers'!E" & B1)

Enter a number in B1


Gord Dibben MS Excel MVP

 

[Dave Peterson]

=index('order numbers'!e:e,a1)
where a1 contained that number

or with minor validity:

=if(a1="","",index('order numbers'!e:e,a1))