hi experts
Need a macro that well copy data from Userform frmform1 to Userform frmform2 if the user know that the two details are the same.
i.e. if the Site A Address details in form frmform1 are the same as Landlord Address then the user can click the macro button in form frmform2 "Copy Address Details" and these would be populated into the Landlord address field.
i have not yet set up a button to open up the user form from the fornt page of the worksheet....as yet.