| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows using key data
I have 2 worksheets, Sheet 1 and Sheet 2.Sheet 1 comprise of n rows an
10 columns including a column name called UserID.Sheet 2 has only on column called UserID. Now the task is I want to read userid from shee 2 and delete those rows in Sheet 1 which contain the userids read fro sheet2. Can anyone help me to write a macro for this -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting rows using key data
Hi shylu
The attached file (Deleterows.xls) should help you. regards Zanto Attachment filename: deleterows.xls Download attachment: http://www.excelforum.com/attachment.php?postid=69211 -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting 63,886 Blank Rows Under My Data | Excel Discussion (Misc queries) | |||
| Deleting Rows of Data | Excel Discussion (Misc queries) | |||
| Deleting Rows with data duplicated in 2 columns | Excel Worksheet Functions | |||
| Deleting rows containing common data | Excel Discussion (Misc queries) | |||
| Help - Deleting rows from data tables via a check box | Excel Programming | |||
Linear Mode
