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

You can probably just use a VLOOKUP to update the prices for the
effective... sheet, then the linked other sheets would be updated
(assuming you've got them linked properly).

Let me know if you'd like a more complete instruction.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=399068