J
JBP
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-9>Jan12-16
What kind of macro can I run to extract this data and
place it into an Access Table?
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-9>Jan12-16
What kind of macro can I run to extract this data and
place it into an Access Table?