Dear Sirs,

I work for a public school. We have 60+ employees who can print and copy on two different machines. I need to get a yearly summary (with views per month) of the usage per employee.

Each month I get a xls dumps of each machine. On it is per employee a total number of prints, scans and copies. An employee can make use of either machine, so per month I have two xls files with per employee a different number. These numbers need to be SUM()-ed. The listed employees can vary however: due to pregnacies an employee may leave, while another may take their place.

example

copier 1, month 1:
Employee Copies Prints
x 1 2
y 0 0

copier 2, month 1:
Employee Copies Prints
x 0 2
y 1 0

copier 1, month 2:
Employee Copies Prints
x 4 2
y 0 3
z 0 0

copier 2, month 2:
Employee Copies Prints
x 0 8
y 1 0
z 1 1

etc

total number of prints/scans/copies this year:
Employee month1 month2 etc
x 5 14
y 1 4
z 0 2

How can this be done? I can put the monthly-files into tabs (into one file). I can import them into access and try doing it with SQL.

Thanks in advance for any help!

kind regards, Koen