I am trying to have my worksheet automatically enter the time, date, and year in my columns if I enter a number in a cell. Below the the worksheet example. I have used the formula =IF(E2=""), IF(A2<>""A2,NOW()),"") but it won't work for me and I also want the date and time to be static and not change. I have tried TIME and TODAY and DATE and obviously I do not know what I am doing. If I could do this as a macro in the worksheet that would be better then entering the formula in the cells as this spreadsheet currently is 14865 lines long and will get longer. Below is an example of my spreadsheet and if I enter information into column E I want the spreadsheet to auto enter the information in columns A, B, C. Thank you.
A B C D E
date year time caller suite
7/1/2008 2008 1:13 AM Dan 250
7/1/2008 2008 1:57 AM 1115
7/1/2008 2008 10:05 AM 1534
7/1/2008 2008 10:58 AM Jean 850
7/1/2008 2008 11:44 AM 1750
7/2/2008 2008 2:20 AM 1362
Bookmarks