Macro - Search ID, then copy and paste data

[sgp]

Hi All

I need help with a macro please! I have two worksheets:

1 - User Form - This is where the user will enter details

2 - Saved Entry - This is where the information would be stored when clicked on the macro, however I would like the macro to search the ID in column B and then paste the data next to the ID in column C to L.

I have been trying to put this together but I’ve not been able to!!

I have attached an example.

Cheers!!

[nilem]

Try this:

Please Login or Register  to view this content.

[sgp]

Omg it works!!!! Thanks a lot!!!!

Much appreciated!!

try this:

Please Login or Register  to view this content.