Macro needs to copy all rows when filtered

[celeazul]

Hi,
Please see attached.
Can you please help me fix the macro on the black tab?
So when I filter the yellow tab by column L and then Column I, it copies on to the black tab whatever i filtered on the yellow tab?
Same thing for the purple tab called Transactional Report.

Please advise. And thank you in advance.

Cele

[David A Coop]

Hi Cele,

I loaded your file; applied a filter on both the yellow and purple tabs; and executed the two macros.

They appeared to work!

What is it that you want fixed?

Regards,

David

[celeazul]

is it possible to have data from column J on the yellow tab to paste on column I on the black tab, please?

[David A Coop]

Hi Celea,

I made this change to your macro.

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[celeazul]

do these two macros "move from yellow tab" "move from purple tab" have the capability that when filtering as:

1) confirmed
2) by Date (confirm or order)

It copies and pastes whatever you filter by? It seems it does it some times and sometimes it doesn't.

[David A Coop]

I don't think I understand your question, but have made a couple of changes to your macros.

Now, if you have NOT set a filter, you will get a message to remind you.

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[celeazul]

Please see this new attachment. Please see the Cancellations Report tab.
The same way that macro behaves, is the same way I want the other two macros on the Invoice Audit tab.
Can it be done?