A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

linking 2 work sheet to update one sheet



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2004, 10:43 AM
andy
external usenet poster
 
Posts: n/a
Default linking 2 work sheet to update one sheet

hi all i am trying to update a price list with part
numbers i have 2 list with part no and prices but i need
to be able to update the old one from the new one with
upto date prices i.e if part number x224 on sheet one is
the same as x224 on sheet two then update price for that
part no x224 from sheet 1 to sheet 2 if part no is new on
sheet 1 then add part no and price to sheet 2 thank for
the help if any one can
Ads
  #2  
Old March 30th, 2004, 11:16 AM
Frank Kabel
external usenet poster
 
Posts: n/a
Default linking 2 work sheet to update one sheet

Hi
you may have a look at VLOOKUP for updating existing parts in your old
worksheet:
e.g.
=VLOOKUP(A1,'new_sheet'!$A$1:$B$1000,2,0)
where col. a stores the part number and column B the price

for adding missing items to your list you may have a look at
http://www.cpearson.com/excel/duplic...#InOneNotOther


--
Regards
Frank Kabel
Frankfurt, Germany


andy wrote:
hi all i am trying to update a price list with part
numbers i have 2 list with part no and prices but i need
to be able to update the old one from the new one with
upto date prices i.e if part number x224 on sheet one is
the same as x224 on sheet two then update price for that
part no x224 from sheet 1 to sheet 2 if part no is new on
sheet 1 then add part no and price to sheet 2 thank for
the help if any one can


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 OfficeFrustration.
The comments are property of their posters.