Hi. I have the attached workbook with 2 sheets. I would like the first sheet to automatically exclude the data from the second sheet. This first sheet will be overwritten regularly by a much larger range of data and rather than having to manually find the test cases from the second sheet I was hoping there was an automatic way to do this. Any help would be much appreciated.
Basically:
Sheet 2 will always be the same data and never change.
Sheet 1 will continue to grow more rows as more support tickets are added to our database.
I wanted to check to see if there is an easy way to automatically remove the data from sheet 2 when the new data is added to sheet one and overwrites the original. It will eventually grow to 10,000s of rows and its quicker to add all the data to sheet 1 and overwrite this as some items may change, rather than trying to pinpoint specific tickets through the reporting engine we use to obtain the data.
Bookmarks