cb977
12-02-2015, 03:07 AM
Hi,
So I have spent considerable time trying to find a way to move ENTIRE rows from one worksheet to another, If the value in the "Date" column is in the past. Unfortunately I can't put up a copy of any of my attempts as I have since deleted them, but so for I've tried: Selecting rows and cut/copying them (I managed to select the rows, but Excel can't cut with a multi selection), then I tried to iteratively select/move rows and I could select and cut the rows but was using pastespecial on a range and it wouldn't work, then I tried to filter the data (to get all the rows with past dates together) instead of selecting it, I could get it to filter and select it but again the paste wasn't working (also that didn't work ideally as I am already using a filter across a row and doing it that way moved the filter). I've also tried stitching other code from this and other forums, lots of people have asked how to do similar things, but with no success.
I have a screenshot of my current set up, but can't post it as I need a post count greater than 5 :'( Basically I have 12 columns, headers are in rows A and B (so obviously I don't want to ever select those), one header is date.
I am trying to get it so that all the rows that have dates in the past (expired licences) are moved to another sheet so I don't have a cluttered workbook but I don't lose the information in case people need their old licence numbers or we are audited and they ask for a past licence.
Already eternally grateful for any help,
-C
So I have spent considerable time trying to find a way to move ENTIRE rows from one worksheet to another, If the value in the "Date" column is in the past. Unfortunately I can't put up a copy of any of my attempts as I have since deleted them, but so for I've tried: Selecting rows and cut/copying them (I managed to select the rows, but Excel can't cut with a multi selection), then I tried to iteratively select/move rows and I could select and cut the rows but was using pastespecial on a range and it wouldn't work, then I tried to filter the data (to get all the rows with past dates together) instead of selecting it, I could get it to filter and select it but again the paste wasn't working (also that didn't work ideally as I am already using a filter across a row and doing it that way moved the filter). I've also tried stitching other code from this and other forums, lots of people have asked how to do similar things, but with no success.
I have a screenshot of my current set up, but can't post it as I need a post count greater than 5 :'( Basically I have 12 columns, headers are in rows A and B (so obviously I don't want to ever select those), one header is date.
I am trying to get it so that all the rows that have dates in the past (expired licences) are moved to another sheet so I don't have a cluttered workbook but I don't lose the information in case people need their old licence numbers or we are audited and they ask for a past licence.
Already eternally grateful for any help,
-C