Add Account Status to Code 'Filter'

[75Rupert]

Hello,

On the Interface sheet there are shapes 'Filter' and 'Clear' which runs code. The 'Filter' runs to advanced filter from range G5:I6 and 'Clear' will clear the data. I would like to add the column for Status in column Y. The code does not include this column yet. The criteria for column Y is like I put in column AA from conditions in cells W3:Y6 that will fill column Y.

I hope that my explanation of what I would like the codes to do is clear.

Please let me know if any further explanation is necessary.

Thank you very much for your help,

Rupert

Please Login or Register  to view this content.

[75Rupert]

I think the column needs to be added to the Accounts sheet with the status. I manually entered the column with the status of each invoice. The filter goes to debug now to put the data on the Interface sheet.

Can someone please take a look at the changes?

[75Rupert]

I got lucky by trial and error.

The new code along with the extra columns in the Interface and Accounts sheets.

Please Login or Register  to view this content.