georgegizmo
New Member
- Joined
- Mar 30, 2007
- Messages
- 11
In the FAQ area I found some info regarding my question, tried to adapt the info to my situation but was unsucessful. I would greatly appreciate some assistance.
The cells in rows 1 through 13 and columns A-H have various client info such as address, phone, date of birth, etc and this area has been frozen.
Beginning with row 14 I have merged B14-E14 so that B14 cell is now a large space (cell) for noting any documentation or action taken on that person's account. When a notation is made in B14 I would like a date and time stamp to automatically occur in A14. Then likewise a few days later when a note is entered in B15 a date/time stamp automatically occurs in A15 and so forth.
Before today I have never attempted or was even aware excel would do someting like this so please give me simple instructions. I am aware that you right click on the sheet tab and select "view code" but from that point I am lost. Please help!!
The cells in rows 1 through 13 and columns A-H have various client info such as address, phone, date of birth, etc and this area has been frozen.
Beginning with row 14 I have merged B14-E14 so that B14 cell is now a large space (cell) for noting any documentation or action taken on that person's account. When a notation is made in B14 I would like a date and time stamp to automatically occur in A14. Then likewise a few days later when a note is entered in B15 a date/time stamp automatically occurs in A15 and so forth.
Before today I have never attempted or was even aware excel would do someting like this so please give me simple instructions. I am aware that you right click on the sheet tab and select "view code" but from that point I am lost. Please help!!