-
1
- #1
I want to create a simple macro to help enter check numbers and amounts in two columns of an excel spreadsheet.
I would like to start out by entering with check number one, then when I hit {enter} the cursor jumps to the amount column to the right. After inputting the check amount and hitting {enter}, the cursor jumps down one and left one to record check number two. The macro would then repeat itself so that the check numbers and amounts can all be entered without having to move between the fields without the arrows or mouse.
Any suggestions?
I would like to start out by entering with check number one, then when I hit {enter} the cursor jumps to the amount column to the right. After inputting the check amount and hitting {enter}, the cursor jumps down one and left one to record check number two. The macro would then repeat itself so that the check numbers and amounts can all be entered without having to move between the fields without the arrows or mouse.
Any suggestions?