Copy rows based on one cell value and in reference to another cell value and paste on a new sheet

Viewed 318

I have to create a report where I get a raw data with a list of transactions, I need my macro to send each transaction to its respective sheets based on if Portfolio name at C Column

I manged to do that, but now I need Transaction of Nokia that fall under 'Cash' from the below given reference sheet, to paste under sheet "Nokia - Cash"

Raw Data Workbook UPDATED

Reference Sheet

Can someone please help me build the 2nd part of my code which helps to move the if C=Nokia and J = Semi Paid then move to Nokia - Cash?

1 Answers
Related