Posted by Vic on September 30, 2001 5:11 PM
I am a new user of Excel 97 (windows 98) and am trying (with no success) to create a macro to move across a worksheet and then down one row to the beginning point for another entry. I prefer to hit the Enter key to make all cell movements.
A B C D E
Name Check # Amount
1 Vic 1 100
2 Joe 2 200
3 Pete 4 150
I would like to go from A1 press enter and goto C1 then press enter and goto E1 then press enter and go down and back to A2.
All entries will occur within a specified range.
The amount blank columns will vary between different worksheets. The worksheet could have 2 blank columns, only one or none. I realize I could hide the blank columns but would rather not.
Also, I was wondering if a macro could be created that, after entering information in the required cells of the first row, would allow the cursor to move to the same cells that ahve the entries made in them as listed on the first row.
Also, please advise as to how to install the macro as my workbook is a Template.
I realize the above reqest is rather substantial but would sincerely appreciate anyones help in trying to solve my problem.
Thanks and "lets Roll"