Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Linking (possible VBA)
Guys,
I have a workbook with 2 worksheets, "Info Page" and "Quote Sheet" On the "Info Page" I have cells with drop downs Price level... Wholesale or Retail Material...... Granite or Silestone on the same worksheet I have named ranges (Granite_Wholesale, Granite_Retail etc) that have 32 rows and two columns I would like to have the named ranges from the info page "appear" on the quote sheet when the appropriate combination of cells is chosen. If the user choosed Price Level (Wholesale) and Material (Granite) then the named range for Granite_Wholesale appears in a designated spot in the "Quote Sheet" worksheet. Will this require VBA to work or is there a formula? Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Linking (possible VBA)
Assuming that they are DV dropdowns, you can select ALL of the target cells
on the sheet and use =INDIRECT(price_level_cell&"_"&material_cell) which needs to be array entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "S Willingham" wrote in message ... Guys, I have a workbook with 2 worksheets, "Info Page" and "Quote Sheet" On the "Info Page" I have cells with drop downs Price level... Wholesale or Retail Material...... Granite or Silestone on the same worksheet I have named ranges (Granite_Wholesale, Granite_Retail etc) that have 32 rows and two columns I would like to have the named ranges from the info page "appear" on the quote sheet when the appropriate combination of cells is chosen. If the user choosed Price Level (Wholesale) and Material (Granite) then the named range for Granite_Wholesale appears in a designated spot in the "Quote Sheet" worksheet. Will this require VBA to work or is there a formula? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking named ranges | Excel Discussion (Misc queries) | |||
linking to a named range in another workbook | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Linking to named ranges in another workbook | Excel Discussion (Misc queries) |