help with updating spreadsheet
 

hi all,

I’m new to excel and learning as i go. i need help, I’m trying to make
my work a bit easier. i want to keep a historical record of products
and there locations at work (work in a warehouse by the way), I’ve
managed to create a worksheet (see below, worksheet 1) that uses
vlookup (=VLOOKUP(Sheet1!A:A,Sheet2!A:B,2, FALSE)) to get a list of
about 4000 products and there locations from worksheet 2, worksheet 2
is updated daily by importing a text file.

what i can't figure out is how to update work sheet 1 using a
formula/macro, one that updates the location of what’s already on the
list (list is column A) in the next empty "location" column (in this
case column C) and if that product number is no longer on the list on
sheet 2, leaves the cell under column C blank or ******. Also, adds
any new product numbers at the bottom of the list in column A (no
duplicates) and the location in the next free "location" column (in
this case column C), but leaves all data already in the worksheet
(historical record).
I’m happy to paste formulas on a daily bases to the next free column if
it is difficult.

I hope I explained what I’m after clearly; any help anyone can give me
would be gratefully received.

Please remember I’m new to this and may need it explained as simple as
possible :)

Thanks again

TPN LOCATION LOCATION LOCATION LOCATION LOCATION
1843 BA010
6947 BX080
11838 BG780
12618 BI129
13679 BW610
13698 BH260
21786 BR900
21807 BR699
21813 CA520
21826 CA719
21859 BT699
21871 CZ450


--
JAZZNAURA
------------------------------------------------------------------------
JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961
View this thread: http://www.excelforum.com/showthread...hreadid=567215