Forum Discussion
How to set tab order of cells in Excel
I've been searching for a method to set the tab order in my sheet.
In this situation, I'm entering the time for hourly employees (skipping over the salaried employees), so it would go B4 to D4 to F4 to G4 to H4 then to B8 and so on.
I found one example that provided a string of code to be inserted via View Code and the Visual Basic Editor, but I could never get that to work.
Any suggestions?
Office_Manager_Brad What is the reason for not grouping your hourly and salaried employees together? It seems like the easiest solution here is to have the hourly employees in columns B thru F, followed by the salaried employees in columns G and H.
Also, what is the significance of having multiple blocks of data for Billable, Non-Billable, Timesheet and Office Misc? Does each block represent a single day? If so, do you have a "Date" column somewhere in your actual dataset that identifies the day?
It's possible to improve data entry efficiency simply by rearranging your data in a manner that accommodates the order in which you read/input the data from the source document(s). Just a thought...
One possibility is to use sheet protection (with a null password) and allow unlocked cells only to be selected.
PeterBartholomew1 I did see that idea online but I don't think that would work when I'm done entering timesheet hours and then going back to the top to enter billable and non-billable hours (which I intended to use a variation of the tab ordering on; i.e., B2 to B3 to C2 to C3 and so on). Even with multiple sheet protections (one for the time, another for the billable -- is that even a thing?), it still wouldn't create the proper sequence that I'm looking for.
Fair enough. It looks like it's back to VBA then. The trick is to get the right balance between helping the user and appearing over-controlling. Also the addressing needs to be sufficiently robust that adding an employee doesn't wreck the functionality.
