Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I have an excel sheet open.....?
I will be using this sheet for entering in work order information. Is there a way to set tabs to switch to pre-selected fields? Like, if I am currently in space A1, and I want to go to B4 when I hit tab, can I set it up to do that, or do I have to double click into each cell?
1 Answer
- Anonymous1 decade agoFavorite Answer
Unfortunately there is no EASY built in way. However, if you were at all familiar with programming VBA in excel, you could do this very quickly. In case you are, the code and the explanation are here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=...
If this is too much past your excel experience, I'm willing to help you out. Make up your sheet the way you want it, indicate the tab order you would like, remove all sensitive data (actually remove all data if possible) and send it to me. I'll code it for you for free (1 time deal, no ongoing support or updates). If you accept this answer, I'll post a temporary email where you can mail your sheet, I'll reply within a day or so with your sheet and it's working tab order.
Another route is to take a course or buy a good book on programming VBA in excel...it'll pay off many times over.
cheers