![]() |
#1
|
|||
|
|||
![]() Good morning forum, What would be the VBA code to delete the rows that contain in column A one of the values listed in another spreadsheet, in column A too? Workbook1, sheet1: 1200 rows, with a number in column A. Workbook2, sheet1: 43 rows, with a number in column A. The numbers don't follow and are not in order (e.g. - in A2, A3, A4 : 45366, 43801, 43471, 46514...). In workbook1, I need to delete the rows that contain in column A a number listed in Workbook2. And cherry on top, the list in workbook2 may increase from month to month... I know how to write the code to delete a row that contains a certain value, but I have no idea how to do it with a list of values. Thank you so much in advance to anyone who can help me. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get all rows based on input values from a list | soolsen | Excel | 1 | 03-27-2016 08:11 PM |
![]() |
get4hari | Excel Programming | 1 | 10-02-2015 04:51 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
![]() |
beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
![]() |
Bathroth | Word VBA | 1 | 10-01-2014 01:40 PM |