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).
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).