Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with updating spreadsheet
hi all, I知 new to excel and learning as i go. i need help, I知 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致e 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痴 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知 happy to paste formulas on a daily bases to the next free column if it is difficult. I hope I explained what I知 after clearly; any help anyone can give me would be gratefully received. Please remember I知 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating a spreadsheet in 1 field w/ out changing values in anoth | Excel Worksheet Functions | |||
Creating spreadsheet of Outlook emails | Excel Discussion (Misc queries) | |||
how do i locate the cell linking to another spreadsheet | Excel Discussion (Misc queries) | |||
Updating links monthly... | Excel Worksheet Functions | |||
Updating data into one spreadsheet from another | Excel Discussion (Misc queries) |