I have a worksheet that consists of over 22000 rows of data. I'm using the data in each row to populate a rating engine I've built on another worksheet. Once the rating engine calculates and displays the results for that row I capture them and place in a results worksheet. Once all that is done, I would like to delete that row. Is there a way to automatically delete a row every "n" seconds? I really don't want to sit here and click delete 22000 time.
Thanks Alan