Nope.

You need some of that VBA stuff.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

bowlesa wrote:

Thanks but this is a bit tooo far advanced for me. Is there an eaiser way? -
am not sure what to do shall i just highligh cells and right click somewhere?

"JE McGimpsey" wrote:

Look at the archives using the URI I gave you - there are dozens or
hundreds of examples.

See http://cpearson.com/excel/ontime.htm for more help on OnTime.


In article ,
"bowlesa" wrote:

Please can you tell me how to go about applying the below: onto a work sheet.


--

Dave Peterson