Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing another worksheet / passing name from curr. sheet
I need to have some worksheets reference each other. It's probably easiest
to give a simplified example of what I'm trying to do: WORKSHEET NAME: FRUIT CELL B8 HAS VALUE "ORANGE" CURRENT WORKSHEET: CELL A1 HAS A VALUE "FRUIT" << NAME OF THE OTHER WS NOW, I WANT CELL A2 IN THIS CURRENT WORKSHEET TO 'GET' THE VALUE "ORANGE" FROM THE B8 CELL IN THE "FRUIT" WORKSHEET. I'm trying to do something like: The formula for cell A2 of the current sheet (if I type it in manually) turns out to be: =FRUIT!B8 but I want to be able to pass the worksheet name from cell A1 of the current sheet, like this: =A1!B8 but of course that doesn't work. So, how do I automatically pass the value from A1 of the current worksheet so that it recognizes it as the name of the other worksheet for this formula? Thanks, Drywall Goddess P.S. Description of actual application: Each worksheet represents a purchase order for receiving purposes. Sometimes, products from 2 different vendors are "split" shipped via the same trucker. In this case, some of the F/A from one vendor is applied to the purchase from the second vendor. Other information is shared from the second vendor by the first vendor. I name the worksheets with the purchase order numbers. I have a little switch that indicates "this" PO is a split shipment. Then I just put in the number of the 'other' PO and I want the worksheet to go get what it needs from that other worksheet. Make sense? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing another worksheet / passing name from curr. sheet
As a guess you can get away with using the indirect function, something like
this =indirect(A1) & ":B8" -- HTH... Jim Thomlinson "Drywall Goddess" wrote: I need to have some worksheets reference each other. It's probably easiest to give a simplified example of what I'm trying to do: WORKSHEET NAME: FRUIT CELL B8 HAS VALUE "ORANGE" CURRENT WORKSHEET: CELL A1 HAS A VALUE "FRUIT" << NAME OF THE OTHER WS NOW, I WANT CELL A2 IN THIS CURRENT WORKSHEET TO 'GET' THE VALUE "ORANGE" FROM THE B8 CELL IN THE "FRUIT" WORKSHEET. I'm trying to do something like: The formula for cell A2 of the current sheet (if I type it in manually) turns out to be: =FRUIT!B8 but I want to be able to pass the worksheet name from cell A1 of the current sheet, like this: =A1!B8 but of course that doesn't work. So, how do I automatically pass the value from A1 of the current worksheet so that it recognizes it as the name of the other worksheet for this formula? Thanks, Drywall Goddess P.S. Description of actual application: Each worksheet represents a purchase order for receiving purposes. Sometimes, products from 2 different vendors are "split" shipped via the same trucker. In this case, some of the F/A from one vendor is applied to the purchase from the second vendor. Other information is shared from the second vendor by the first vendor. I name the worksheets with the purchase order numbers. I have a little switch that indicates "this" PO is a split shipment. Then I just put in the number of the 'other' PO and I want the worksheet to go get what it needs from that other worksheet. Make sense? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing another worksheet / passing name from curr. sheet
I should give up while I am behind... Ardus is correct in his use of
Indirect... =Indirect(A1&"!B8") -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: As a guess you can get away with using the indirect function, something like this =indirect(A1) & ":B8" -- HTH... Jim Thomlinson "Drywall Goddess" wrote: I need to have some worksheets reference each other. It's probably easiest to give a simplified example of what I'm trying to do: WORKSHEET NAME: FRUIT CELL B8 HAS VALUE "ORANGE" CURRENT WORKSHEET: CELL A1 HAS A VALUE "FRUIT" << NAME OF THE OTHER WS NOW, I WANT CELL A2 IN THIS CURRENT WORKSHEET TO 'GET' THE VALUE "ORANGE" FROM THE B8 CELL IN THE "FRUIT" WORKSHEET. I'm trying to do something like: The formula for cell A2 of the current sheet (if I type it in manually) turns out to be: =FRUIT!B8 but I want to be able to pass the worksheet name from cell A1 of the current sheet, like this: =A1!B8 but of course that doesn't work. So, how do I automatically pass the value from A1 of the current worksheet so that it recognizes it as the name of the other worksheet for this formula? Thanks, Drywall Goddess P.S. Description of actual application: Each worksheet represents a purchase order for receiving purposes. Sometimes, products from 2 different vendors are "split" shipped via the same trucker. In this case, some of the F/A from one vendor is applied to the purchase from the second vendor. Other information is shared from the second vendor by the first vendor. I name the worksheets with the purchase order numbers. I have a little switch that indicates "this" PO is a split shipment. Then I just put in the number of the 'other' PO and I want the worksheet to go get what it needs from that other worksheet. Make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing values in Sheet to VBA | Charts and Charting in Excel | |||
passing a variable from sheet to form to another sheet | Excel Programming | |||
Insrt curr file name & name of active worksheet respectively | Excel Worksheet Functions | |||
multilple sheets using days of curr month! | Excel Programming | |||
passing values from one sheet to another | Excel Programming |