Hi
I am trying to find a macro that will filter on Column F (non-blanks - just cells with dates) cut just the filtered data (A:G inclusive)without the Header Rows and then paste/move this data to the first empty row on another sheet called "Complete"
So that I get the cells in columns A:G with dates in moved to the "Complete" tab and they are no longer in the sheet "Deliverables"
Can any one help me out please?
I have looked at lots of various macro answers online and am completely stumped - I keep getting error messages when I try to adapt examples to my requirements! Hope this makes sense
Attached is a file with 2 pathetic attempts at the above!
Many thanks in advance
Rae
Bookmarks