Filter, copy and paste data from one worksheet and paste the data into the relevant named worksheet

[GKDVBA]

Hi

I have spreadsheet where there are rows of data and I would like to try and filter the values in column C one by one and copy the filtered data and paste into the relevent worksheet.

The data i want to filter is called "room name" and the worksheets i want to paste the data into are named as the different room names.

Please help

thanks

 

[GKDVBA]

basically it is one workbook with multiple workseets names after each room and then there the main worksheet where all the data is. there is already data in the other worksheets so i would like to paste the filtered data at the end of data that is already in the relevent work sheet