Copy Data to multiple Worksheet Based on cell values

[Negi1984]

Hi All,

I have an workbook. and below sheets contains :-

1) RAMSES : this is main sheet from where I need to copy only column F and paste in multiple sheets. based on cell value mentioned in column C.

2) CTA : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "CTA"

3) IDF : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "IDF"

4) MED : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "MED"

5) NOE : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "NOE"

6) SWT : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "SWT"

7) WST : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "WST"

8) BLANK : data needs to paste in this sheet if any cell value of column C in Ramses is mentioned as "#N/A" or any Blank Cell in column C in Ramses.

I have attached the sample file as well in below link.
https://1drv.ms/x/s!Ap80Ku6M2Tw5gTbGRwA5Q6nGCIGO

Thanks in advance for your valuable support.

Regards,
Rajender

 

[PCL]

You are welcome
A nice day to you to