Link 2 excel workbooks

Faith-

There are several different approaches to accomplishing your end result.  I have attached an example file that contains two methods (Please see attached). :

1. Dynamic Column pull using Vlookup()

2. Dynamic Column pull using Offset()

Here is how the data is set up:

Both of these example also use the weekday function and the today function.

Please see additional information regarding these functions here:

https://support.office.com/en-us/article/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9

https://support.office.com/en-us/article/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a