dual lookup pages

J

joeldsmt

I dont know if this is even possible but here goes.

I currently have a workbook that has two sheets. Sheet1 is a page that
i use to provide my customers with quotes on products. it is filled
with formulas and all i do is enter data in the provided fields.
Sheet2 is a look up table. It has part numbers, decriptions, prices
and others values needed to automatically fill in the fields when i
enter the corresponding part number.

My problem is this. I need to update the lookup table(sheet2) with all
of our recent price revisions as well as any new part
number(descriptions, prices) that i may have created since this was
originally created.

I dont know how to make this work? If i just make a Sheet3 it will
have double entries and conflict in prices.

Does anyone know how i can merge the two tables so that the original is
kept but any new changes and additions will be added?

Please, any assistance in this matter would be greatly appreciated. I
am not really knowledge able on how to do it in VB so if there is
anyway that this can work please let me know.

Thank you so much in advance.

JM
 
B

BrianB

Don't really understand the problem. Your basic setup seems perfect
Seems all you need to do is update your price list (presumably a simpl
table with column headings and records underneath) and put new items a
the bottom.

Perhaps your linking formulas need changing a bit
 
Top