NoSparks,
Thanks for your time and the solution to my query. It works perfectly.
Now, users are asking if possible to have focus move across the range. For example: a date is entered in column D, an entry from a dropdown in column E (data validation list), a customer name is typed in column F, and a dollar value entered in column G. Problem is, focus moves down after entries in columns D, E, and F, not across - Excel default. Can you modify the code to move across the row, and leave the move after the G entry as is?
Next, after an entry in G57 (last cell in the first range), have focus move to J7 (first cell in the second range)?
These moves will save users much time by not having to use the mouse to move to the next cell as they post. Guess I should have anticipated this. Mea culpa.
Thanks, Phil
|