delete after specific value in column

Hi,

I am trying to delete all rows below a specific point in my data. I would like a macro to find the last value in column I that is greater than 0 and then delete all rows that follow that value. Can it be done?

Thanks

Z

May be:

Please Login or Register  to view this content.

Thanks both, I have moved on a little since this post and tried to combine two macros so that the copy and paste is done first then delete out anything below the last value that is greater than 0 in column I. Any idea how to combine the two?

Please Login or Register  to view this content.

@stnkynts, Brilliant idea.
@zak.horrocks, you could use this.

Please Login or Register  to view this content.

You can append this code below your code

Please Login or Register  to view this content.