| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Rows beased on Values
I have values that are on Sheet1 in Range A5:A100. On
Sheet2 I have values that are in Range in B3:B97. I need a code that will look in the Range on Sheet1 and for each value in that range, if it does not find that value in the Range on sheet2, will delete the value in the range on Sheet1 as well as the entire Row that the value is located on. Thank you Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows based on column values | New Users to Excel | |||
| Deleting rows based on values in a a cell in the row | New Users to Excel | |||
| Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
| Deleting rows with specific values | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
