i have a worksheet which collects specific data from numerous sheets in excel. I have added a timestamp to each of these cells so when they are updated the date and time of update is displayed beside that cell. Im wondering if its possible via use of a vba coded button that will display only the cells that have been updated between two specific dates and times. I.e. Previous 24hours but i wud like to be able to specify the start and end time in the vba code. The idea is to have a button for each day of the week that id press and only b shown the the updated cells which i cud then printout for a daily review meeting. Any help or tips would be greatly appreciated!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
24hour data lookup with button
- Thread starter Steg00
- Start date
-
- Tags
- vba button
