• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy to another tab in same work book based on date and "confirmed"

C

Cele

Member
Hi,
I was wondering if someone can help me with this macro. Here's the objective.
I want rows that are filtered by date and by "confirmed" to be moved to the black tab.

1) I want that when i filter column I (to a particular date) say everything in Oct. on the yellow tab
and column L when its filtered to show "confirmed" only to be copied and pasted to the black tab.

2) On the purple tab, same thing, that when i filter column G for dates, and column J for "confirmed" that it copies that to the black tab.

Can someone please help?

Thanks in advance,

Cele
 

Attachments

  • 2016_ Reports-xlsm.xlsm
    685.7 KB · Views: 5
1) Do You want to 'copy' like [a] new line or ...
anyway both case are possible.
2) All three tabs has different structure (=outlook) like ...
'Yellow' [A] Eng Specialist | 'Purple' [A] Consulant | 'Black' [A] Consulant
and so on ... of course, there are also some same columns, but ...
before I would like to do this, I would like to be sure
 
Last question, is it possible to move the rows in the yellow tab (Renewal Report) that are marked as Cancelled to the Cancellations Report tab in maroon? See attached here
 
Actually the button should be on the "Cancellations Report" see this attachment. Thanks.
 

Attachments

  • Copy of 2016_ Reports-xlsm-3.xlsm
    682.3 KB · Views: 2
Your file is older version.
Of course, I can make a new button there, but it don't work - no Macro.
... and that the newest Macro (in #9 Reply-file) moves rows (not only copies).
see #9 Reply attached.
 
You must log in or register to reply here.
Back
Top