Need a row moved to another WorkSheet if it has a date within last week

[mikerevans]

Hi everyone,

I have been tasked with producing a weekly report of work done inside a spreadsheet. We would like a script that runs through the sheet, and copies every row that has a date in it from previous seven days, into another sheet.

Please can you help me achieve this?

Regards,

Mikexcel

[Olly]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[mikerevans]

Firstly thank you for replying. I have attached a sample workbook, with any data desensitized. I just need a check in place to read the date fields, if it recognizes a date from within the past 7 days, then it is to copy that row into the "After" sheet.

MTIA

Mikexcel

[Olly]

Which column(s) contain the date(s) you wish to check are within the last 7 days?

[mikerevans]

That's just it, I need it to check all of the columns that have dates in.

[Olly]

Ok. SO try something like:

Please Login or Register  to view this content.

[mikerevans]

Excellent, thank you so much!

Mikexcel

[Olly]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to users who helped you. Thanks.

[mikerevans]

Just one more quick question, is it possible to put in a prompt to enter the date we would like to look 7 days back from?

Thanks,

Mike

[Olly]

Something like this:

Please Login or Register  to view this content.

It's not clear whether you wanted to limit it to dates within that 7 day window (as the code above does), or whether you want ALL dates after 7 days before the manually entered date? If the second case is your requirement, then simply delete this bit:

Please Login or Register  to view this content.