Copying from another worksheet

  • Thread starter Thread starter Wayne26el
  • Start date Start date
W

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
 
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")
 
=index('order numbers'!e:e,a1)
where a1 contained that number

or with minor validity:

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