| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows that do not match values in dynamic range.
Hi every one,
Please help vba/excel newbie! I have 3 sheets with columns SKU and Quantity. Sheet1 is raw data. Sheet2 is in house stock and Sheet3 is outside stock. What I need is to loop through the rows in sheet1 and check if the SKU exists in Sheet2 if not copy the row into Sheet3. The problem is that the SKUs in Sheet2 (the one I'm matching against) change all the time so I can't hard code them. Thanks in advance for any advice! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions | |||
| Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
Threaded Mode
