Pete
06-08-2008, 03:29 AM
Hi
Is it possible to dynamically generate name ranges based on information in columns B and C......and that the name range always follow a set pattern....
=(Vol_Alternative_Suppliers_Other_Markets_EU * Price_Other_Markets_EU_Alternative_Suppliers) - (Vol_Alternative_Suppliers_Other_Markets_EU * (Price_Alternative_Suppliers_Other_Markets_EU + UFC_Alternative_Suppliers_Other_Markets_EU))
the only part of the formula tha changes is the supply customer name and the demand customer name........
in the shown example i.e.
Vol_Alternative_Suppliers_Other_Markets_EU
Alternative_Supplier = Supply customer and
Other_Markets_EU - Demand customer...
see attached workbook........
Is it possible to dynamically generate name ranges based on information in columns B and C......and that the name range always follow a set pattern....
=(Vol_Alternative_Suppliers_Other_Markets_EU * Price_Other_Markets_EU_Alternative_Suppliers) - (Vol_Alternative_Suppliers_Other_Markets_EU * (Price_Alternative_Suppliers_Other_Markets_EU + UFC_Alternative_Suppliers_Other_Markets_EU))
the only part of the formula tha changes is the supply customer name and the demand customer name........
in the shown example i.e.
Vol_Alternative_Suppliers_Other_Markets_EU
Alternative_Supplier = Supply customer and
Other_Markets_EU - Demand customer...
see attached workbook........