Hi all,
I have two workbooks, one consolidated data sheet with about a 100 names like this:
Home - imghst free image hosting - View Image
and I have to generate one workbook per name with the data and Chart for each name from the Source book as in the below image:
Home - imghst free image hosting - View Image
(tried uploading pictures, maybe it's the wrong website to use because the pictures aren't displaying in Preview)
would I be able to do this with array formulas in a Template book, so all I have to do is change the name and the formulas would get the right data for each individual, and the Chart would be correct.
If so, how would I do that, can you help?
Or would I be better off building a macro to create one workbook for each person from the source workbook?
This is as you have probably guessed for HR Dept.
working in Excel 2003
thanks for any help
Philip
I have two workbooks, one consolidated data sheet with about a 100 names like this:
and I have to generate one workbook per name with the data and Chart for each name from the Source book as in the below image:
(tried uploading pictures, maybe it's the wrong website to use because the pictures aren't displaying in Preview)
would I be able to do this with array formulas in a Template book, so all I have to do is change the name and the formulas would get the right data for each individual, and the Chart would be correct.
If so, how would I do that, can you help?
Or would I be better off building a macro to create one workbook for each person from the source workbook?
This is as you have probably guessed for HR Dept.
working in Excel 2003
thanks for any help
Philip
