Copy paste data after filter

Hi
I need a help to create a macro. In the attached sheet I have a tab named Raw data. One of the fields in that sheet is PID column “B”. I have different tab for each PID.
Now…

1. I have to filter each PID from column B, copy the data for all the column and paste it to respective tab. For example I have to filter “AA0967” copy the data and paste it in “AA0967” sheet in the respective area.
2. I have to do it for all the PID

I’ve given a sample. No of data is huge , so if it is possible to write a macro code it will help me a lot.

I have tried but having some issue. Each time I’m filtering the PID, cell ref getting changed.

Any help will be much appreciated ………..

hi, Abhijit2011, please check attachment, run code "test"

PS. In order for the code to run Sheet "Raw Data" and Sheet "Template" should exist.

Excellent! Working gr8
Thanks pal

But actually there is another reuirement which forgot to mention. In the actual data there will be hundreds of PIDs (column B). But i need it for 10 projects from my area only.when i tried this macro in my original sheet it created separate tab for all the PIDs where as i need it for 10 only. For example here i needs the data for all except "BB2333" and "EE2677". How will i do it?

excellent!!!!!!!! U R gr8. Many thanks

Please mark this as solved as i'm not able to do it.