Can I create a button auto delete a row?

[ulhotboy1]

I am able to download or export Trustee Sale information from this website:http://64.6.222.36/stpsocivil/realestateSL.html into an excel spreadsheet very easily in Window Internet Explorer. My problem is 2 fold:
1st. Take a look at line 13. The export transfered the "STOPPED" value into a row of it's own. I would like to create a button that checks this columun for any variables that say stop. Once it finds the word "STOPPED", cut and paste it into the the cell directly above it. Then delete the row that "STOPPED" was cut from. This feature would need to check the entire column.

2nd. Columun E, The export tranferred the street address into one cell. I need to put the address, city, state, and zip into individual cells. I assumed there's a way to create a program that would do the following:

1. Insert 4 colomuns to the right of E
2. Copy/Cut everything to the right of the 1st comma into the 1st new columun.
3. Copy everything between the 1st comma and space to the 2nd comma into the new 2nd colomun
4. Repeat step3 until you reach the end of the list or after the zip code has been copied and moved.
5. delete columun E

I attached the spreadsheet to this post. Let me know if I am being unrealistic with the program.

Thanks in advance for your help.

[p24leclerc]

Hi, this code should take care of deleting the "STOPPED" rows .

Please Login or Register  to view this content.

I'm working on part 2 of your question.
Pierre

[p24leclerc]

Hi again,
here is a macro to do all you wanted to do. Look at the attached file.
Pierre

[ulhotboy1]

Thanks for help. Is there anyway that you could copy the answer into the forum thread? Don't want to download files to my work computer. Thanks for your help.

[ulhotboy1]

Hi, this code should take care of deleting the "STOPPED" rows .

Please Login or Register  to view this content.

I'm working on part 2 of your question.
Pierre

This code didn't work the way I wanted it. The code needs to Cut Stopped from the cell and paste it directly above it's previous position. So if you look at the attached file, cell A13 should be cut and pasted to cell A12. Then Row 13 should be deleted and the formula should move on to the next Stopped cell.

Thanks in advance for your help.

[p24leclerc]

I corrected the first part of the macro to copy Stopped to the previous row.
Here is the code
Pierre

Please Login or Register  to view this content.

[p24leclerc]

This new code is probably a little bit better. Pierre

Please Login or Register  to view this content.