I am after a vb scritp that will copy information from sheet 1 to sheet 2 of course this is a sample test sheet but I will be able to import into actual sheet.
Just to add the fields that refer to Name & No need to repeat the info per line were the address is so if omly 2 lines filled in the NAme and No appear on the 2 lines.