I've seen a few responses on the board on how to solve this but they all seem far too complicated for the actions I need to do.
I want to create a simple history of dates... in column F the user fills in the current date, and all I want is for this date to jump to column G leaving F blank, and then the same thing to occur when we want to enter another date, so that the second date will be entered into F, go to G, and then the first date to go from G to H, and so on. So basically a +1 rule in the column.
I understand that I need to use a macro and for some reason all the ones I've come across that seem relatively simple have no effect on my enteries.
PLEASE HELP I'm a excel newbie!
Bookmarks