| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inventory compare and copy Script
Situation: I need a script that will search through two worksheets and
find serial numbers that are the same. Than I need to copy the asset ID from the first sheet into the correct one on the second sheet. Example Sheet1 AssetID Desc s/n 123 stuff 1 124 junk 2 125 tools 3 Sheet2 AssetID Desc s/n thing 4 junk 2 tools 3 stuff 1 I need them both to have the asset ID numbers that are in Sheet1. I was trying to do an IF statement but I don't know enough about programming in excel (or in general) to set it up correctly. Can anyone please help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and copy for inventory | Excel Worksheet Functions | |||
| VB Script in Excel to copy a row | Excel Worksheet Functions | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
| VBA Script for copy and paste to save | Excel Discussion (Misc queries) | |||
| script/macro that can compare data of two columns | Excel Programming | |||
Threaded Mode
