Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If data is returned then delete data | Excel Worksheet Functions | |||
Delete data | Excel Discussion (Misc queries) | |||
Delete rows with no data | Setting up and Configuration of Excel | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |