How do I set up a standard form showing incentive calculations

G

Guest

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.
 
P

PC

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
 
G

Guest

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
 

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

Similar Threads

how do i set up borders around pages in excel? 1
I want to set up a time sheet? 2
How do I filter data from a master worksheet to other worksheets 1
How do I get excel to "count" cells along a row? 2
how do i set up a list of customers in excell for mail merge 3
How do I copy page set up in Excel using VISTA 1
How do I set uo a template of formulas in excel 1
how do i set up a time stamp if another number entered in cell? 1

Top