Macro needs to copy the correct info in the correct column, please help

Hi,
I was wondering if someone can help me.
At the moment the most of the macros on this spreadsheet are working fine.
However, when I filter the Revenue Report tab (yellow tab) by confirmed, and then go to the black tab (invoice audit) and press the copy from yellow tab button, it copies most of the data correctly.

However there is something its doing incorrectly.
One of the columns thats copying over, is copying it incorrectly. Here's what it should do...
I need that whatever is in column J on the yellow tab (Revenue Report), to copy to column I on the black tab (invoice audit).
Can you please help?
Thank you in advance.

Cele

AttachmentSize
2016_ Renewal and Transactional Reports.xlsm757.65 KB