Hi
Could anybody tell me how I would do the following please?
I have a date in cell H3 which is 31/12/15 and I have text in cell O3 which is "12 Months".
What I would like to happen is that what I type into O3 be automatically added on to the date in H3.
ie I would like H3 to be 31/12/16.
Can somebody help please?
Thnx
Em
Please find the attached sheet to see if this is what you are trying to achieve. The sheet1 contains a Worksheet_Change Event code. Right click on Sheet1 tab --> View Code to see the code.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks