ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   create button to find today's date in another tab (https://www.excelbanter.com/excel-worksheet-functions/225108-create-button-find-todays-date-another-tab.html)

kjedgar65

create button to find today's date in another tab
 
I am trying to create a spreadsheet where by pressing a button on the front
page it will take me to another tab where there is a rota of support person
covering in date order. I would like the button to go to and highlight the
day's date that I am currently on.

Simon Lloyd[_151_]

create button to find today's date in another tab
 

This can certainly be done, however you need to supply more information,
where would the support persons name appear?, is the destination tab the
same name as the support person? is it always todays date that you would
want or would you want to select a data? if so what would be the date
range?

kjedgar65;278770 Wrote:
I am trying to create a spreadsheet where by pressing a button on the
front
page it will take me to another tab where there is a rota of support
person
covering in date order. I would like the button to go to and highlight
the
day's date that I am currently on.



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77867



All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com