Can i run a Macro on dynamic data??

[james_edstrom]

Hi,

I produce a report (example attached) each week, and need to know if i can run a macro on it so that certain rows are deleted from the sheet, depending on the what the text in the row says?

On the attached example, i need to basically delete any row that has (PARCEL ACCOUNT) after the company name e.g. cell A15 in the attached.

One factor that might complicate this is that the companies listed on the report may not be extracted to the same cell / row each week as the data extracted changes from week to week, and is therfore ordered differently each time.

I know how to create a macro to delete the same cells or rows each time the macro is run, but i need this one to only delete rows that contain the word PARCEL.

Could anyone help me please??

Many thanks in advance

James

[Andy Pope]

Please don't post the same question in multiple forums.

I'm locking this one as you have a reply at your other post