how to Copy data from one worksheet to another worksheet..Data should be copied on new rows every time

[Pramodp]

Hi,

Please help me in this problem.

I have my data in worksheet 1 with Row headers..Like Name, City, Assignment,Date. Now worksheet 1 is having list of 100 members in Column1 and they will be assigned 2-3 type of assignment on daily basis. Assignment will be entered on Column 2..Date will will entered into Column 3.

I want to copy assignment for every date mentioned in Worksheet 1 to Worksheet. As this is for record so i want to paste data in new line of worksheet 2 so that previous record may maintain.

All these activity should be performed if date entered will math to current date.

Action will be performed with any command button..

Please help how this could be done