D
djm
Any suggestions here..??....I have monthly time sheets that ar
completed in WORD. I receive them electronically and then transcrib
the data (hours worked, time off, the reason for any absence assigne
to a code) into an Excel spreadsheet for each employee. I am dealin
with close to 90 staff doing this on a monthly basis, and so th
workbook is fairly large and the transcribing seem
never-ending...
......the Excel file, of course, is great fo
compiling info on a monthly and a YTD basis.....but, I would like t
automate (or at least, ease) the transfer of info from the individua
WORD time sheets to the individual Excel spreadsheets in the Exce
workbook......any suggestions??...or should I set up the time sheets i
an Excel format--would that help??.......or should I look at doing al
of this in something like MS ACCESS...I have never used ACCESS, bu
should I??......thank you in advance for any help (as always, this sit
and the people who participate in it are very helpful)
completed in WORD. I receive them electronically and then transcrib
the data (hours worked, time off, the reason for any absence assigne
to a code) into an Excel spreadsheet for each employee. I am dealin
with close to 90 staff doing this on a monthly basis, and so th
workbook is fairly large and the transcribing seem
never-ending...
......the Excel file, of course, is great focompiling info on a monthly and a YTD basis.....but, I would like t
automate (or at least, ease) the transfer of info from the individua
WORD time sheets to the individual Excel spreadsheets in the Exce
workbook......any suggestions??...or should I set up the time sheets i
an Excel format--would that help??.......or should I look at doing al
of this in something like MS ACCESS...I have never used ACCESS, bu
should I??......thank you in advance for any help (as always, this sit
and the people who participate in it are very helpful)