View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kcoppoletta kcoppoletta is offline
external usenet poster
 
Posts: 1
Default Delete all row data EXCEPT

I have imported data from an Outlook file that leaves me with an excel
spreadsheet with 2 columns. Data in the columns include groups that I must
keep in the following format:

In column A: I have 8 fields named
txtBusiness,txtName,txtAddress,txtCity,selState,tx tZip,txtEmail,and txtPhone

In column B, I have the actual data. However, I also have a lot of other
garbage in column A and B that I do not need and would like to delete with a
macro. I have searched the knowledge base high and low and have found
nothing that seem to fit this application. I simply need to save any row
that has the txtBusiness through txtPhone in column A and the corresponding
data in column B, and delete everything else. Thanks in advance