LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Macro to delete ROWS in a spreadsheet using Text file

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to merge text and delete rows nospaminlich Excel Programming 2 January 18th 08 03:16 PM
Macro to delete certain rows in a spreadsheet Gary Excel Programming 2 June 11th 07 05:03 PM
VBA macro to delete rows that contain text Rod from Corrections Excel Programming 2 January 25th 07 07:36 PM
Macro/VBA to delete rows in Spreadsheet Colin Foster[_5_] Excel Programming 5 June 17th 06 12:47 PM
Macro to delete rows with text cells zsalleh Excel Programming 8 August 27th 04 12:22 AM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"