E
encise
I need to create and populate a large number of individual excel
workbooks using data contained within a single summary workbook. The
summary workbook lists 90 sales employees and their respective
financial targets. The summary data needs to be populated into 90 new
individual workbooks - each based on a model that contains headers and
logos.
_Existing_Summary_Workbook_
Employee 1
Employee 2
....
Employee 90
_I_need:_
Employee 1 Workbook
Employee 2 Workbook
...
Employee 90 Workbook
etc.
Is there a quick method in which I can do this? There are plenty of
sites containing info on how to link mulitple workbooks into one - but
not the opposite! I dont know VB and Access doesnt extract data to
existing models - only new workbook templates.
Any assistance would be appreciated. Thanks all...
workbooks using data contained within a single summary workbook. The
summary workbook lists 90 sales employees and their respective
financial targets. The summary data needs to be populated into 90 new
individual workbooks - each based on a model that contains headers and
logos.
_Existing_Summary_Workbook_
Employee 1
Employee 2
....
Employee 90
_I_need:_
Employee 1 Workbook
Employee 2 Workbook
...
Employee 90 Workbook
etc.
Is there a quick method in which I can do this? There are plenty of
sites containing info on how to link mulitple workbooks into one - but
not the opposite! I dont know VB and Access doesnt extract data to
existing models - only new workbook templates.
Any assistance would be appreciated. Thanks all...