| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete row if columnA and ColumnB are same
I have one big excel spreed sheet, on the ColumnA is call
staddr, and ColumnB is call mailaddr, if both column as same address, example "123 main street" then I need to delete entire row, can everyone show me how to write with VB script. I will be really appreciated it. Lillian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF value columnA columnB | Excel Worksheet Functions | |||
| sum up columnA depending on conditions on columnB and columnC | Excel Discussion (Misc queries) | |||
| Count cells that contain "Y" in columnA IF contains"X" in columnB | Excel Worksheet Functions | |||
| Delete Row Containing "x" in ColumnA in 2 Worksheets | Excel Discussion (Misc queries) | |||
| Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
![Lillian[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
