In Excel 2003, I have a 2 page workbook. First page is all items and prices.
Second page is like a "catalog order form" with same items, same prices and
a field for quantity ordered.
neet to be able to paste in new prices on the first page, to
automatically update prices on second page.
since I add items often, the sequence will be different (slightly) whenever I update the prices.

.... I did this once before using SUMIF function and naming columns on both
pages, but can't find my notes and can't seem to recreate it.

To get the prices just use VLOOKUP

=VLOOKUP(item_no, Sheet1!table_ofitems_and_prices,2,False)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Greg" wrote in message
...
In Excel 2003, I have a 2 page workbook. First page is all items and
prices.
Second page is like a "catalog order form" with same items, same prices
and
a field for quantity ordered.
neet to be able to paste in new prices on the first page, to
automatically update prices on second page.
since I add items often, the sequence will be different (slightly)
whenever I update the prices.

... I did this once before using SUMIF function and naming columns on both
pages, but can't find my notes and can't seem to recreate it.