Macro - Copying items from the yellow tab to the red tab

[Cele]

Hi,

Can someone please help me with this macro?
I want to be able to filter items in the yellow tab (Renewal Report) by column I (date) and column L. So that say i want to filter the cancellations for a particular time frame, it copies it to the red tab called Cancellations Report.

For some reason right now its doing two things I DO NOT want it to do which is (hide the red tab, and move the rows).

I want to:

1) keep the red tab (Cancellations Report) visible.
2) I want to be able to filter items in the yellow tab (Renewal Report) by column I (date) and column L.
3) filter the cancellations for a particular time frame, it copies it to the red tab called Cancellations Report.

Can someone please help me with this? Thanks in advance

CBW

 

[vletm]

Hi again ... You're continue this file.
Previous time You wanted moving, I can left there only copy option, Okay?
This version don't hide 'Cancellations Report'-tab and
it copies only rows which has 'Cancelled'-text in Column-L...
so only that 'time frame' is missing... Okay?
How do You want to tell/set 'time frame' ?

 

[Cele]

Thanks for your quick response. I want the "Cancellations" button to behave like the other two buttons. Only difference is, I want it on the "Cancellations Report" tab. And I want so when it filters anything that on column L reads cancell. And any date i pick on column I, it copies these rows that say "cancelled" on column L, copy the whole rows, to the Cancellations Report tab. But note it should copy the rows, not paste it and remove it from the yellow tab. So it essence, this third button should behave like the other two created on the black tab.

And the Cancellation Report tab should not be hidden at all.

Thanks.

 

[vletm]

2nd sentence - done
3rd, 4th sentence - done before
5th sentence - only copy.
6th sentence - 'original buttons back'
7th sentence - with one version it hides ONLY if operator wanted.
if needed more stronger 'no hidden-option' ... just ask

There is NO special 'time frame' option.

Check/Test/Report Attached File

 

[Cele]

Is there anyway you can remove the little pop up window that says Move ...rows? when its about to copy the rows on the Cancellations Report tab, please?

 

[vletm]

Moved => Copied

... be careful with duplicates and
if You manually clear rows ... clear only necessary rows,
not 'hidden rows'.

Check/Test/Report Attached File

 

[Cele]

So what you're saying that there's this window can't be removed?

 

[vletm]

'Pop-up' has left the Macro ( 'from all three buttons' )
... if You want one or two of those back,
just remove the 1st character of that row

Check/Test/Report Attached File

 

[Cele]

You are a genious and a rock star!!
This looks fantastic.
You are the best..
Thank you, thank you thank YOU!!!

 

[vletm]

be careful ...