Hey guys and gals, I figured out how to use the =Vlookup to get a result based on a range of dates on a yearly schedule.

The Lookup factor is a =today() so when the workbook is opened, the calender worksheet can scroll to the Schedule of the week containing today's date.

I got the vlookup result, but for the life of me, I can not automate the "Goto" for the result found.

For example: The "Calender" worksheet has data down to row 1485. every 28 rows, there are dates for the week of scheduling.

I have created a range with all of the dates in Colunms of 7. the 8th column is the row the data is located on.

How do I create either a Macro or a VBA code to get the workbook to open up to the Calender worksheet down to the row of the current date based on the Vlookup result?