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.


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=399068