Auto populate based on user input

**lotusblossom** · 01-19-2011, 02:57 PM

Hello,

I would like to have a user input the year (yyyy) only into a cell and based on their input have the adjacent cell populate with the upcoming year.

Example:
B6 2008 (user input) --- C6 2009 (automatically populates to the next year)

How do I configure the cells to replicate the example above.

Thanks,
Lotus

**TMS** · 01-19-2011, 03:08 PM

Well, if it's just a number ... 2008 ... in cell B6, C6 could have B6+1 to give you 2009.

Regards

**lotusblossom** · 01-19-2011, 03:22 PM

Thanks, TMShucks.

Have a great1

**TMS** · 01-19-2011, 05:05 PM

You're welcome. Thanks for the feedback.

**royUK** · 01-20-2011, 02:58 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save