Simple V Lookup Macro to paste data

[Celticfc]

Hi all,

I want to make a simple database - I already have a list of User ID's in Column A.

I would like clients to enter their User ID in F1, DOB in G1 and Location in H1.

I would like to add a macro button where once clicked, it should look for the User ID and paste DOB and Location in to columns B and C.

I would really appreciate any support. Many thanks in advance.

 

[cooper645]

I have tagged Fluff, hopefully he can cast an eye over this as he has held me before.