Macro that copies all rows filtered

[Cele]

Hi,
Can someone help me fix this macro.
I want when i filter all items that are "confirmed" on the Transactional Report tab, to copy all confirmed rows on to the Invoice Audit tab when i click move from purple button.
Can you please help?
Thank you in advance.

 

[vletm]

@Cele
Is that Macro some of old Macros .. or something new?

 

[Marc L]

Hi !

As Range.Copy method uses only visible cells (so filtered data), it's easy !
Another way is to use an advanced filter …
And don't forget Macro recorder, best beginner friend !
​

 

[Cele]

@Cele
Is that Macro some of old Macros .. or something new?

Old macro. Just noticed its not copying the first row.

 

[Cele]

see file attached

 

[vletm]

@Cele
see file attached

 

[Cele]

is it possible to have it move only stuff that says "confirmed" and not have it move everything?

 

[vletm]

@Cele
Yes,
as You wrote #1:
when i filter all items that are "confirmed" on the Transactional Report tab
I read that 'i' like You. So, You should filter it first.
I did Your previous wish #4: Just noticed its not copying the first row.

 

[Cele]

You see the same way that the "move from yellow tab" folder behaves when it comes to filtering, that's the same way I want the "move to purple tab" operates. So when filtering on the Transactional Report tab, it copies and paste to the invoice audit tab when clicking the "move to purple tab"

 

[vletm]

@Cele
I asked new or old code ... You answered old, but it's new - clean!
There are no filtering with those codes ... or it shows always all.
Cause new code, I don't want to try to change too much ... btw old code worked.
Hint, You should try to hint from #3 Reply

 

[Cele]

Hi !

As Range.Copy method uses only visible cells (so filtered data), it's easy !
Another way is to use an advanced filter …
And don't forget Macro recorder, best beginner friend !
​

I seem to be having an issue. Can you shed some light? Please see attached.

 

[Marc L]

Any comment ?!
​

 

[vletm]

@Marc L
A long time ago this code worked. (#10 Reply)
After that, someone change & clean it ...
Now, code do just what code has asked to do ...
but it don't work as Cele wants ...
good luck for Cele

 

[Deepak]

This is what she is looking for!!