I have a spreadsheet with the 7 days of the week in one row I'd like to be able to move to the next row after I hit the enter key when I'm in the last day of week I need to do this repeatedly on the same sheet ( moving from cell I5 to C6, I6 to D7 and so on...)
When you go form C5 to I5, if you use the tab to move from cell to cell, at the end (at I5) when you'll finally hit the enter key, Excel will reposition itself to C6.
If this is not enough, you'll need a macro to do that.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks