Automating a data checking routine
 

Hi,

I perform a data checking routine twice a week and I would
love to know how to automate it.

Col S contains a figure that is subtracted from 2 dates
(ColQ - DateOfCheck and ColR - DateOfLastUpdate). If the
figure is greater than 6 days I need to extract data from
3 cols: Col A, Col R and Col S and have this info copied
to a new worksheet (Sheet1) so that I end up with a list
of companies that have failed to send in updates. There
are 30 companies in my list but it may grow at some stage
in the future.

Grateful for any responses.

Tony