Delete Cells Current Region Dynamic Range

Hi,

I would like to have a macro which would look at the last column of range a1 current region. If the cell's value is CANCELED, I'd like for it and all cells back to the left on the same row to column A to be deleted and shift cells up. For example on today the last column of the range a1 current region might be column G. Therefore if in column G the cell's value is CANCELED, that cell and all cells to the left back to column a on the same row will be deleted. Tomorrow the last column of a1 current region may be column J. I'd like to do the same starting at column J back through column A on the same row. I use row one for my header row. Any assistance you provide will be greatly appreciated.

Thanks for responding TMS. I will attach the sample file. Thanks again.

How about

Please Login or Register  to view this content.

Fantastic, thank you Fluff works like a charm.

You're welcome & thanks for the feedback