VBA - Filter data in 2 sheets and copy to single 3rd sheet

[abhinavj]

I have a need to filter data in 2 sheets and copy to 3rd sheet.

Please refer to attached file.

Filter data in Sheet Apr on Payment = Cash

Filter data in Sheet May on Payment = Cash

Copy filtered data to Sheet Consolidated (filtered data from Sheet Apr followed by filtered data from Sheet May)

[#2]

@abhinavj Why not collect all data in one table? Add a column with the date/month and filter on the payment type of your desire.

[#3]

@Riny_van_Eekelen - thank you for your response.

The issue is that the data gets pulled from a legacy tool in this format in separate sheets

Also, this is just dummy data to explain the requirement, the actual data is quite different with several columns :)

[#4]

@abhinavj What stops you from putting them together? Otherwise, have a look have at PowerQuery. It can do these sort of things without much trouble. Have only recently started using it myself, as I only used to work on Excel for Mac for years. The attached file contains a simple example that took less then 5 minutes to create. Others out here can probably help you creating a very flexible solution, better than I can.