Data Merge

[MauriceP]

I have 2 Excel sheets. One sheet is titled TIMESHEET and the other EMPLOYEES. On the TIMESHEET I have one cell for a persons full name and another for the position worked. On the EMPLOYEE sheet I have 2 columns, one titles FULL NAME and the other POSITION. Let's assume I have a list of 10 employees. I would like to produce 10 copies of the TIMESHEET with the proper names and positions of each employee on each individual sheet.

I assume this is a simple task, but the solution has evaded me. Any help would be appreciated.

Maurice

[vidhyakrr]

Please provide a sample spreadsheets, will try to solve your problem

Thanks & Regards,
Vidhya

[MauriceP]

I hope the file has attached to this message.

Maurice

[Toonies]

Hi try this

Timesheet D11

Please Login or Register  to view this content.

Timesheet D12

Please Login or Register  to view this content.

Place this in a Module then Create a Button on Timesheet and assign Macro AddSheets

Please Login or Register  to view this content.

[MauriceP]

Thank you Toonies, this worked very well. I am slowly starting to understand formulas etc., but macros are still a bit of a mystery to me.