Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
Edit Links: make update manual | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Manually update links | Excel Worksheet Functions | |||
Update Individual Links | Excel Discussion (Misc queries) |