Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a script that will work?
Hi, I have a sheet where columns A-D are given, sorted ascending to col A. I have data in another sheet A and B where col A *may* match a value in sheet 1,col A. I need to do this for sheets that may contain up to 3000 rows. The sheets may or may not contain the same numbers of rows. I need to match if possible the BarCd located in sheet 2 and bring along the Location column with it and place it in the same row as the matching value in sheet 1. Thanks in advance :) Ray Example:Sheet 1 BARCD - UII - NOMEN 27122 - LDW53W9LD2217 - LCHR GREN RIF M76 MC 27123 - LDW53W9LD2218 - LCHR GREN RIF M76 MC 27126 - LDW53W9L157974 - PISTOL PYRO AN-M8 15 27127 - LDW53W9LE068750 - PISTOL PYRO AN-M8 1 5 29235 - LDW53W9L8036268 - TELEPHONE CELL W/CAM 29238 - LDW53W9L8790941 - TELEPHONE CELLULAR Sheet 2 BARCD - LOCATION 29235 - 13 29240 - 13 29243 - 13 29247 - 13 29250 - 13 29251 - 13 29239 - 13A 29245 - 2074 29238 - 2532 29246 - 3149 29249 - 3325 27122 - 3327 27123 - 3327 27126 - 3327 27127 - 3327 -- RayB ------------------------------------------------------------------------ RayB's Profile: http://www.excelforum.com/member.php...o&userid=33499 View this thread: http://www.excelforum.com/showthread...hreadid=562492 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script doesn't work when cells are merged. | Excel Discussion (Misc queries) | |||
Why won't this simple VDB script work on Excel 2002. | Excel Programming | |||
Why won't this simple VBA script work in excel 2002? | Excel Discussion (Misc queries) | |||
Excel 2000/XP script to Excel97 script | Excel Programming |