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?
Bookmarks