Merging Workbooks

D

Diane

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top