I am copying data from another source and pasting into my spread sheet. Currently I am manually sorting this data by column I (ascending). I then delete the rows that have any values in column I. I don't necessarily need the data sorted by this column, I am only sorting by this column to make it easier to find and delete the rows with values in column I. If a macro can be created to delete required rows without sorting, I would prefer that.
Any help with this would be appreciated.

Thanks.