I have two documents (although they could be used as two sheets in one workbook). One is a form and the other is a list of data that needs to be populated into the form and printed.
Similar to a mail merge only my form and my data are both in excel.
There are 5 different sets of information that need to be populated, NAME, POSITION, HIRE DATE, SUPERVISOR and DEPARTMENT (columns A - E) to be populated into cells C5, C7, C9, C11 and C13 on the form.
Thanks
Similar to a mail merge only my form and my data are both in excel.
There are 5 different sets of information that need to be populated, NAME, POSITION, HIRE DATE, SUPERVISOR and DEPARTMENT (columns A - E) to be populated into cells C5, C7, C9, C11 and C13 on the form.
Thanks
