PDA

View Full Version : use date stamp to trigger Shift:=xlDown?



gringo287
10-14-2012, 06:49 AM
Hi

Is it possible to use a date stamp to trigger Shift:=xlDown.

Simon Lloyd
10-14-2012, 11:58 AM
In what scenario? during use of the workbook, on activation of the workbook? on activation of a worksheet? selection of a cell? and how should the check be done, what will you compare it to?...........etc

There are lots of questions that we'd ask, above are just a few, you need to give us more information in order to help you.

gringo287
10-15-2012, 01:15 AM
sorry, i was a bit vague.

i would want it to be triggered when the user opens the workbook at the start of their shift, so that the previous days number of calls are shifted down