Every time a date appears in Column B that is less than or equal to 30 days before today’s date I want to cut that entire row and paste it into a new row in Sheet2. If I was looking for a specific word or number I could easily use the code above but since today’s date is always changing, I am not sure how to write the search term so it works. Any direction I appreciate.
Please Login or Register to view this content.
Last edited by EJensen; 07-16-2009 at 05:51 PM. Reason: SOLVED
Hello EJensen,
This macro copies the entire row of the cell in column "B" of "Sheet1" to column "A" of "Sheet2" if the date is no more than 30 days from today. The worksheet names and starting cells are marked in red. You can these to match what you are using.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you for your assistance. Perhaps I made a mistake. I think I followed your instructions correctly, however I am getting an error message, when I run the code, on this line.
Set RngEnd = DstRng.Cells(Rows.Count, DstRng.Column).End(xlUp)
Any input is greatly appreciated.
Hello EJensen,
That was my fault. Here is the corrected code...
Please Login or Register to view this content.
This is awesome. Thank you Leith Ross. Where do I find the scales to click on so I can rate the answer?
Hello EJensen,
Look on the right side of the title bar of your post. The icon is to the right of the post number.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks