Button To Navigate In Excel
I’ve tried to find something that might work for this but have been unable to find anything.
My work we use excel to manage our schedule and everyone’s appointments and whatnot. We have a row with the days of the week sequentially and everyone’s appointments for that day are within a column. ie JA is the column for 21 Sep, JA3 is where the date is listed, and JA8 thru JA78 is where an appointment would be added for a specific person.
I would like to know if there’s a way to add a button in our header rows that will select either the cell that has the current day’s date, or better yet select the whole column that contains the date.
Thanks for any help!
I’ve tried to find something that might work for this but have been unable to find anything. My work we use excel to manage our schedule and everyone’s appointments and whatnot. We have a row with the days of the week sequentially and everyone’s appointments for that day are within a column. ie JA is the column for 21 Sep, JA3 is where the date is listed, and JA8 thru JA78 is where an appointment would be added for a specific person. I would like to know if there’s a way to add a button in our header rows that will select either the cell that has the current day’s date, or better yet select the whole column that contains the date. Thanks for any help! Read More