Need VBA code to clean up downloaded data

arecube

New Member
Joined
Feb 24, 2006
Messages
46
I am trying to make a download from a web report to Excel so that it can be made into a Pivot Table.

I am looking for VBA code to examine row after row of a field, keeping records that have the first letter of Z or the first 2 letters of Ty. These fields with Z and Ty have blanks preceding the letters. The records in column A that are kept would then need to be parsed from column A and blank cells need some content like zero or dash for the Pivot Table to work.

Other rows may be blank, start with ** or other letters. They should be deleted (other than headers in row one). Hopefully the action will stop after the last record.
Thanks for any help you can lend.

I am using Excel 2003 (Office 2003).
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Forum statistics

Threads
1,216,082
Messages
6,128,709
Members
449,464
Latest member
againofsoul

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top