J
JKarchner
Our timesheets are setup in Microsoft Excel. Each employee has their own
workbook. In each workbook, there is a separate worksheet for each day, and
the worksheets are labeled by the date. In each worksheet there are columns
for the Project Name, Project Number, Task, Hours, Total Hours, and Notes.
Is it possible to automate a procedure to transfer the data to Access from
Excel? This is something i would like to do monthly, because we are now
requiring monthly breakdowns of each employee and also of the amount of time
spent on projects.
workbook. In each workbook, there is a separate worksheet for each day, and
the worksheets are labeled by the date. In each worksheet there are columns
for the Project Name, Project Number, Task, Hours, Total Hours, and Notes.
Is it possible to automate a procedure to transfer the data to Access from
Excel? This is something i would like to do monthly, because we are now
requiring monthly breakdowns of each employee and also of the amount of time
spent on projects.