Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet that has up to 10 columns and xx amount of rows
example below. Unique LName FName City State Zip Phone SpouseName Child1 Child2 ---------------------------------------------------------------------------------------------- TheJones Jones John Lincoln NB 12345 123-4567 Jane jOe Jerry TheBrowns Brown James Austin TX 14782 231-4789 Beth James Linda TheAdams Adams Benny Dallas TX 78965 321-9874 Robin Eddie Alex Now, I have a seperate text file that just has the UniqueName in it. TheBrowns What I want to do is the following: 1. Use the UniqueName in the text file to to delete all rows of data that does not match via the Uniquename in the spreadsheet. 2. So the result of the above should be the following: UniqueName LName FName City State Zip Phone SpouseName Child1 Child2 ---------------------------------------------------------------------------------------------- TheBrowns Brown James Austin TX 14782 231-4789 Beth James Linda Is this possible to do with a Excel Macro. Any and all help in this matter would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to merge text and delete rows | Excel Programming | |||
Macro to delete certain rows in a spreadsheet | Excel Programming | |||
VBA macro to delete rows that contain text | Excel Programming | |||
Macro/VBA to delete rows in Spreadsheet | Excel Programming | |||
Macro to delete rows with text cells | Excel Programming |