Hi,

I am looking for a macro for copy and pasting data based on condition. The
format of data id pasted below.

FSN Plan Name Rate Hrs
1112 ABC Tim $12.00 32
1112 DEF Nick $12.00 176
1245 CCC Tommy $38.00 67
1356 DDE Ricky $25.00 168
1112 FGT Tim $14.00 145

What I require is that entire data based on FSN No. should be pasted in the
diffrent sheet whose name is based on FSN. For example all data of FSN 1112
should be copied and pasted in different sheet where sheet name is FSN 1112.
And data of FSN 1356 should be copied and pasted in sheet FSN 1356.

It would be great if the sheet named on FSN is automatically created.

I request all the member to help me.

Regards

Prem