Hello All,

I am really new to this...
I have an excel spreadsheet that I am capturing time in
eg:
Approved: yes (drop down yes/no)

Resource Name: XXX XXX
Manager Name: XXX XXX

ProjectID WorkType Mon Tues etc
1234 Proj Man 2.5 5
1478 Proj Co 5 2

The above is the template. Now in the spreadsheet there
are different workbooks eg: Jan 5-9Jan12-16

What kind of macro can I run to extract this data and
place it into an Access Table?