xcel VBA Macro to help work scheduling

[karnrai]

Hi, I am entirely new to Excel and coding in general. I have began to start playing around with it in the simplest form but have the desire to start learning.

I am in dire need of something to help speed up a task that I must do daily at work.

I am working on two Excel Workbooks: one is a master list of all of our employees with columns from monday-sunday and the hours they work; the second one contains daily work hours log with employee names. Currently I look at each name one by one in daily log finding match in the master Workbook and typing in each employees hours for that day.

Question: is there a way to create a VBA macro that matches the names between the two workbooks, and automatically types in the daily hours of that employee if he/she is working - and leaving it blank if they are not?

this is the data, the first workbook is the following:
image removed

Column B is our work force, and column C is what I am trying to automatically capture - employee shift time from the other workbook by name. This is a daily log we post for the workers in the lunch room so they know where they are working for the day This is where the employee shift times are coming from:
image removed

for example, tomorrow Tuesday would capture the information from column J. Let me know if anything else is needed! Thanks so so much.

Any help would be appreciated!!!!!!!!

<tbody>
[TD="class: votecell"]

​

[/TD]
[TD="class: postcell"]
[/TD]

</tbody>

 

[deletedalien]

you could just use an index match.... and have it look for "Monday" "Tuesday" etc...

​How to use INDEX MATCH instead of VLOOKUP. Learn Microsoft Excel | Five Minute Lessons

 

[karnrai]

you could just use an index match.... and have it look for "Monday" "Tuesday" etc...

​How to use INDEX MATCH instead of VLOOKUP. Learn Microsoft Excel | Five Minute Lessons

Hi, I think ive figured out how to use it in one workbook, how would I do it using two different work books?

 

[deletedalien]

Its pretty much the same except you redirect your references to the other workbook,

Also you could try a two dimensional lookup,

Here i've created this one and i think its just what you need.

https://www.dropbox.com/s/rpkbsd5asm0u9ws/Two Dimmensional Lookup.xlsx?dl=0

oh and ignore G1:H2 on sheet 2 that was just a test to get it to work. G1:H2 on sheet one is what you need