Transfer Data to separate tables based two variables (date and site)

I have a spreadsheet where raw data is entered ("RAW_DATA") for each month it is collected.

There are 7 questions that are tallied and each of those responses are transfered to a separate data table for analysis (7 individual tabs within the spreadsheet).

I'm currently manually data entering the values from the raw data tab to the other seven tabs.

I would like to have VBA code that could transfer the data from one month ("RAW_DATA") onto the other 7 tabs based on the date and facility identified in the raw data tab.

I have not attempted the VBA since I do not know where to start with searching on two variables.

Any help would be very much appreciated.

Thanks!

Hello yunesm,

This macro has been added to a button on the "Raw_Data" sheet to run the macro below. The macro has already been added to the attached workbook.

Please Login or Register  to view this content.