Ryu
11-10-2008, 04:02 AM
Hi people,
Just a really simple question, I have three worksheets in Excel Sheet1, Sheet2and Sheet3, all of them have different columns however column A is the same (column A is called Date/Time.) I have created a button on Sheet 4 and was wondering would it be possible to run some coding where when the button is clicked on sheet 4 then the current date and time is shown in Column A on all of the sheets from 1 to 3 on a new row?
The format I would prefer would be something like 10/11/2008 13:05
Thanks
Just a really simple question, I have three worksheets in Excel Sheet1, Sheet2and Sheet3, all of them have different columns however column A is the same (column A is called Date/Time.) I have created a button on Sheet 4 and was wondering would it be possible to run some coding where when the button is clicked on sheet 4 then the current date and time is shown in Column A on all of the sheets from 1 to 3 on a new row?
The format I would prefer would be something like 10/11/2008 13:05
Thanks