workbooks

GlennB · May 21st, 2002, 10:42 AM

How do I refer to data in another workbook, such as pricing? Can I refer from an estimate sheet to a price list?

Rocky E · May 21st, 2002, 12:09 PM

Hi Glen,
We need a bit more information. Looking things up in an open workbook is not much problem, but in a closed workbook is a little tougher. Generally speaking the more detail you can provide the better suggestions you will receive. For example what info can you use to lookup the price in the other book? Does the price need to become static or fixed once it is lookup or can it change if the price book changes etc...

May 21st, 2002, 12:09 PM	#2
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Hi Glen, We need a bit more information. Looking things up in an open workbook is not much problem, but in a closed workbook is a little tougher. Generally speaking the more detail you can provide the better suggestions you will receive. For example what info can you use to lookup the price in the other book? Does the price need to become static or fixed once it is lookup or can it change if the price book changes etc... __________________ Hope this helps! Rocky <h6>"Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744).</h6>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 10:42 AM	#1
GlennB New Member Join Date: May 2002 Posts: 1	How do I refer to data in another workbook, such as pricing? Can I refer from an estimate sheet to a price list?