I am trying to use a macro that will look at a date that I enter and find that date adn corresponding data in a different workbook.
For simplicity sake I have included a sample of data in an attachment but in the same workbook for now!
On "Sample Calendar" tab I want to be able to change that date and have it search for that date to fill in the blanks for Breakfast, Lunch and Dinner for the three week section (in theory)
Any and all help is greatly appreciated!
Bookmarks