I'm looking to set up a single sheet that will be used to print out qtrly
bonus calculations for employees - in effect I'm looking to do a mail merge
in excel without setting up a sheet for each employee (90 in total) but
carrying out a variety of calculations on about 9 different paramaters which
relate to circa 20 schemes for the 90 employees. The sheet will read off a
database containing targets v acheivement and variable % entitlements for
different scheme types. Currently I have 90 sheets within my workbook.

Just my 2 cents. If you need to print out letters the Mail Merge in Word is
probably a better choice. All you need is to have the employee names and
their bonus figures either in one XL table or (I'm guessing) you could
probably pull the merge data straight out of Access.

PC


"KeithB" wrote in message
...
I'm looking to set up a single sheet that will be used to print out qtrly
bonus calculations for employees - in effect I'm looking to do a mail
merge
in excel without setting up a sheet for each employee (90 in total) but
carrying out a variety of calculations on about 9 different paramaters
which
relate to circa 20 schemes for the 90 employees. The sheet will read off a
database containing targets v acheivement and variable % entitlements for
different scheme types. Currently I have 90 sheets within my workbook.

Thanks PC,

their are too many permutations of calcs for it really to go into word -
looks like its time to refamiliarise myself with access

KeithB

"PC" wrote:

Just my 2 cents. If you need to print out letters the Mail Merge in Word is
probably a better choice. All you need is to have the employee names and
their bonus figures either in one XL table or (I'm guessing) you could
probably pull the merge data straight out of Access.

PC


"KeithB" wrote in message
...
I'm looking to set up a single sheet that will be used to print out qtrly
bonus calculations for employees - in effect I'm looking to do a mail
merge
in excel without setting up a sheet for each employee (90 in total) but
carrying out a variety of calculations on about 9 different paramaters
which
relate to circa 20 schemes for the 90 employees. The sheet will read off a
database containing targets v acheivement and variable % entitlements for
different scheme types. Currently I have 90 sheets within my workbook.