use date stamp to trigger Shift:=xlDown?

[gringo287]

Hi

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

[Simon Lloyd]

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]

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