Copy rows of data if date in cells meets certain date criteria

Hello all. I have tried and tried to find an example of this code so I wouldn't be bothering anybody, but alas, here I am. What I am trying to do is this: I have a worksheet with several different types of data in it, and in column H I have dates. If a date in that column is either any date in the past before today() or 60 days in the future from today() then i need to copy cells A-H, N, O for that row and paste them into another spreadsheet at B-J, and then continue this for every row in the spreadsheet that meets the same date criteria. Not sure if it matters, but the format I am using for the date is 14-Mar-01. Any help would be much appreciated. Thank you all so much in advance!!!!!

Joseph

Hello Joseph,

try this one, hope I got Your idea

Please Login or Register  to view this content.

Thank you so much for your help!!! I made a few minor tweaks and it is working like a charm! One other question though. I am using the following:

Please Login or Register  to view this content.

to get to the first blank cell in that spreadsheet I am pasting the data to. How do I use the code you gave me and paste to that particular cell that is selected if I don't know the exact location? (Because the data pasted will be different lengths every time depending on the date).

Again, I definitely appreciate your help!!!! You are a life saver!!!

Joseph

Hi,

luckily it is a few days I learned right here from RoyUK a nice way to define the number of the last cell row. It looks like this

Please Login or Register  to view this content.

You can then use the value as You wish, e.g. like this:

Please Login or Register  to view this content.

Knecht