I have a worksheet, containing 380 rows, named ( Effective 1-1-05) that
contains columns named

stock#    mfg#description     each       lot1      lot2
A2                B2                     C2          E2        G2
B92-150     UC-18                 69.02     64.71    60.90

I have formatted worksheets  EA, 50lot, 100lot l
inked to this main worksheet ( effective 1-1-05).

I have a new external excel file with new prices from the mfg that I
now need to update. I'm hoping there is an easier way to update the
records rather than keying in 380 rows with 3 columns of prices.

I can provide formatted price sheet via email to those that are
inclined to help me.