Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
thanks for looking @ this.
Is it possible too. I have a timesheet that users use everyday. It has a column that starts @ 5:00am and goes to 12:00 Midnight. Each Row respresents a Tenth of an hour. In two other cells I have a "Arrival TIME" and " Departure TIME" .. Normally they start @ 8:00am, leave @ 5:00pm .. Both these are DataValidation List using the same 5:00am to 12:00am list. Is it possible too, based on the users selection of ARRIVAL time, to HIDE ROWS in the TIME COLUMN that are less than the ARRIVAL Time? .. if the user comes in @ 8:00 am, it would hide rows from 5:00am to 7:50am .. I would like to do the same with Departure Time.. If the user leaves @ 5:00pm .. it would hide from 5:10pm to 12:00 midnight.. Basically to "shorten" the timesheet up to the hours they are working. I hope I have explained this correclty. Thanks for you help. thom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Rows based on value, but not using autofilter | Excel Worksheet Functions | |||
how can I unhide/hide a sheet based on pull down selection? | Excel Discussion (Misc queries) | |||
Hide row(s) based on drop down selection | Excel Discussion (Misc queries) | |||
Hide Rows based on value | Excel Discussion (Misc queries) | |||
Moving Selection and Time based run macro | Excel Programming |