Hi, I am trying to copy data from one worksheet to another based on the value in the variance column. If the variance is >= 10 or <= -10 then copy the rows data into the investigations sheet.
The All differences sheet is updated daily with a number of new lines based on the date and the number of tills used. I dont know how to make the data range change with every day that i add new data. Any assistance would be greatly appreciated.