I think I would use/add a key column that I can use to match up with the price
book.

For instance, if the user chooses a nice unique item/description/part number in
the Quote workbook, you could use formulas to retrieve the data that you want.

In general, it'll look something like:

=IF(A1="","",IF(ISERROR(VLOOKUP(A1,[book2.xls]Sheet1!$A:$F,2,FALSE)),"Missing",
VLOOKUP(A1,[book2.xls]Sheet1!$A:$F,2,FALSE)))

(that's with the "sending" workbook open.)

If you close that other workbook, excel will adjust the formula to include the
paths:

=IF(A1="","",IF(ISERROR(
VLOOKUP(A1,'C:\My Documents\excel\[book2.xls]Sheet1'!$A:$F,2,FALSE)),
"Missing",
VLOOKUP(A1,'C:\My Documents\excel\[book2.xls]Sheet1'!$A:$F,2,FALSE)))

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())


Marc wrote:

In some cases the prices are linked from the price book to the quote book.
If I make changes added lines to the price book and the quote book is not
opened the the quote books will not update correctly. Correct? If both
books are open I can get around this. Correct? I tried getting some help
with a macro that would do this but I haven't had any but I think that this
would solve the problem. I would like to use a combo box that is populated
by all the matches in column B and than have other cell in the same row bet
filled with the price, cost and time to install. Any suggestions?

I know hire a professional!!!!

Marc:)

--

Dave Peterson