| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying from another worksheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying from another worksheet
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") "Wayne26el" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying from another worksheet
=INDIRECT("'Order Numbers'!E" & B1)
Enter a number in B1 Gord Dibben MS Excel MVP On Tue, 19 May 2009 11:16:04 -0700, Wayne26el wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying from another worksheet
=index('order numbers'!e:e,a1)
where a1 contained that number or with minor validity: =if(a1="","",index('order numbers'!e:e,a1)) Wayne26el wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet formula incorrect after copying to another worksheet | Excel Worksheet Functions | |||
| Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming | |||
Linear Mode
