Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
nander
 
Posts: n/a
Default How to update links between wk sheets


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

  #2   Report Post  
Excel_Geek
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keep value from last update and don't ask to update links jh3016 Excel Discussion (Misc queries) 3 July 25th 05 01:37 AM
Edit Links: make update manual Chrissorr Excel Discussion (Misc queries) 5 May 11th 05 11:57 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Manually update links Emma Excel Worksheet Functions 0 February 22nd 05 01:23 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"