#1
|
|||
|
|||
Delete a row if a specific value exist on another sheet
Can anybody help me I new to VBA and I'm trying to copy data from one sheet to another, then delete any row that is blank in a column, and then delete any row that has a value that is equal to a cell on another sheet that is a named range “House1”? |
#2
|
|||
|
|||
This can certainly be done but it's not entirely clear what you need. It sounds like that you want the data copied to a different sheet and then have a procedure go through and check several conditions. If any of those conditions are true you want it to delete a row. Could you post a sample workbook with the desired result and I would be happy to write something up for you.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete specific text | Jackson | Word VBA | 16 | 12-06-2019 08:24 PM |
Browse to a specific sheet in an excel workbook | Sinister | Excel | 4 | 04-08-2014 05:53 PM |
Exporting workbook specific sheet columns on exit | shabbaranks | Excel Programming | 4 | 08-21-2012 08:00 AM |
Delete sheet through VBA | Salim Khan | Excel | 1 | 08-30-2010 09:11 AM |
Setting up Analysis Sheet when data does not exist, yet. | burnoutdetective | Excel | 0 | 10-13-2008 05:57 AM |