| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro-pawan
I have 2 sheets in same .xls file. In second sheet-column A, I have list of
some values, say 100 values. In sheet 1-column B, I have list of some 2000 values. Values of sheet 2-columnA are present in sheet1-columnB. Multiple instances are also there. I want to find all these values in sheet1-columnB AND OTHER ROWS OF SHEET1 (which doesn't contain values from sheet2) ARE TO BE DELETED. How can we write macro for this? Thank you in advance. -Pawan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink-Pawan | New Users to Excel | |||
| macro to paste data in alternate cells-pawan | Excel Programming | |||
| Macro to find text in all worksheets -pawan | Excel Programming | |||
| how to attach macros to excel permanently - pawan | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
