View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MelNeedsHelp! MelNeedsHelp! is offline
external usenet poster
 
Posts: 1
Default Creating a Macro to Record Lap Times

Hi

I am trying to create a spreadsheet in Excel which will record the lap times
of a number of riders in a bike race. At the moment I have a button in
column A for each of the riders, when the user clicks the button initally the
start time displays in Column B, I'm wondering if it's possible to create a
macro which would record the time at the end of lap one in column C on the
second click of the button, then the time at the end of lap two in column D
on the third click and so on.

Hope that makes sense!
Thanks
Mel