Copy and Paste to other sheets

Hi Everyone,

I really need some help ;-(... I have 3 command buttons that I would like to do the following...

1 - I need to change the macro below to add the record to multiple sheets. (I've been told how to do it but I guess I just didnt hold it in).

Please Login or Register  to view this content.

2 - How can I change this code to find the record by enetring the First and Last name (A1 and B1) click on the command button and some how getting all the fields for sheet2 (A:J) in sheet1 for that record.

3 - Change the code to delete the record (A1:J1) from all the sheets.

Thank you for all your help once again.

Please Login or Register  to view this content.

the code above will copy your info and then Clear Contents of A1:J1 change clear contents for Delete if you wish.

Regards,
SImon