LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Looking for a "Simple" EXCEL Solution

Looking for the Excel Master;

I am using Excel 2002.

I have discovered that I am a REALLY REALLY NOVICE Excel USER. In my
mind I was pretty smug about the "simplicity" of formulae in a cell
until I began to develop some tools as a consultant to a client who is
helping me get through a rough period of unemployment.

I have to admit that I don't even know some of the shortcuts to avoid
going to the dropdown menus for so many of my tasks.

Now, here's my Question with a hopefully "Simple" Solution.

I have created a Workbook with each sheet representing a progressive
process of performing a moving estimate in the home of a client.

There are eight (8) sheets with only a single "page" to each sheet
except one which
is two "pages"/screens.

The client's employee who does the in-home estimating would prefer to
use the TAB Key to move about the "page" and, more specifically, move
from one "entry field" to the next.

Now, due to the difference in the information gathered from one sheet
to the next, they are all formatted quite differently and any one line
of entry information is followed by either empty rows for spacing or
text rows for information before you get to the next entry field.
There are a few instances where the entry fields go across the screen
or row before dropping down to a lower row.

What I am afraid of is that each page would require its own VBA Macro
linked to the TAB Key to accomplish this and that is way beyond me for
the moment since this client has a number of other tasks they are
anxious for me to move on to.

Is there a simple way to "link" one entry field to the next entry
field with the use of the TAB Key? It's these little requests that
keep a client happy.

Right now, the estimator has to enter the information via a keyboard
on a laptop or write it down and do it via a keyboard at home. In the
future, when we feel that PC Tablets are perfected, the entire process
will be a touch- screen operation on a PC Tablet.

I do hope you have a moment to give this some thought and reply to my
inquiry.

Thanking you in Advance,

Duane S. Meyer

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Excel solution - mnthy rtrns using "Modified Dietz" npappous Excel Discussion (Misc queries) 1 March 1st 09 06:18 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Solution "Your changes could not be saved" "The document may be read-only or encrypted" [email protected] Excel Discussion (Misc queries) 0 August 7th 06 06:31 AM
any solution to the "too many cell formats error" in excel? Mini Excel Discussion (Misc queries) 1 May 31st 06 11:45 AM
circular files; iterating to a "correct" solution jefftlewis Excel Discussion (Misc queries) 4 December 8th 05 05:18 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"