Hi Finally this is my first post as I have always managed to find a solution here to my novice VBA attempts!
I am struggling with how to define range of cells to copy and then define range to paste too, (not just the whole row), based on an auto filter being applied.
I have a macro that copies rows from multiple sheets (A:AD) into a summary sheet ("Review") based on YES criteria in col A of each ws. All good!
These rows in the "Review" sheet will be reviewed, with additional columns being completed in AE: AI.
Once review is completed, I then need a macro to apply a filter on AG for "YES", copy visible rows, but only from col E:AF, to another sheet ("JOINTR", same w/book) to next available row (based on col B - this contains a formula that will show as blank until date is entered in col C), and paste special values to col E:AF also. Then copy a date from a fixed cell reference from the "Review" sheet ($I$1) and paste value into col C of "JOINTR" for the rows pasted.
Hope this is enough detail!
Thanks in anticipation.
Bookmarks