I don't know if this is even possible, but this is what I need:

I have a spreadsheet (Sheet6) that contains each individual account record
for a set time period. During this time period we have letters that are sent
out on a regular basis and we monitor how long it takes to receive a
response. When a response hits the time limit that they are allowed to
respond the claim is copied to another spreadsheet for follow up (FollowUp).
I need to know if there is a Macro that I can set up to automatically pull
the accounts that go past the alotted time frame.

So for example:

Row1 is on day 59. When Row1 hits day 60, the macro should automatically
copy that claim information to the FollowUp spreadsheet.

Is this possible?