I have created a workbook containing sales compensation data for 30 sales
reps. I would like to create a commission statement (workbook) for each rep
using excel. Ideally, as data is added to the master spreadsheet, each of
the commission statements would automatically update. I know how to do this
with print merge into a word document, but thought there might be a way to do
it using excel that would allow for the automatic updating of each
spreadsheet.

See
http://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Diane" wrote in message ...
I have created a workbook containing sales compensation data for 30 sales
reps. I would like to create a commission statement (workbook) for each rep
using excel. Ideally, as data is added to the master spreadsheet, each of
the commission statements would automatically update. I know how to do this
with print merge into a word document, but thought there might be a way to do
it using excel that would allow for the automatic updating of each
spreadsheet.