J
JimP
Where can I find documentation on how to use a flat file (table) exported
from MS-Access to create a spreadsheet in Excel that contains subtotals?
e.g. I have an employee timesheet table with (3) columns: Department,
Employee and Hours. I need use this data to create a spreadsheet in Excel
that groups by department, lists each employee (and their hours) and then
subtotals the employee hours for each department - with a grand total.
The spreadsheet needs to be updated monthly and the number of employees by
department can vary.
from MS-Access to create a spreadsheet in Excel that contains subtotals?
e.g. I have an employee timesheet table with (3) columns: Department,
Employee and Hours. I need use this data to create a spreadsheet in Excel
that groups by department, lists each employee (and their hours) and then
subtotals the employee hours for each department - with a grand total.
The spreadsheet needs to be updated monthly and the number of employees by
department can vary.