Returning to home base

[claudehollett]

My sheet opens for manual entry in col B. After that manual entry, VBA code takes me to col E for continued manual entry out to col J. After tabbing out to col J and pressing "enter" Excel takes me back to col E on the next row down. Is there a way to leave col J and be automatically returned to col B on the next row down?

 

[Oaktree]

What's the code your file is currently using? (right click on the sheet tab and go to "view code")

 

[daniels012]

Yes,
You would want to use OFFSET(1,8) to take you where you want to be.

If you don't understand coding, write back I'll give more detail.


Hope this helps,
Michael