Tabbing

We use an Excel spreadsheet to keep generation and lake elevations where I
work.
At 07:00 and 19:00 we have to enter in extra information.
How can I set the sheet up so that at those hours we can tab directly to
those cells after entering our regular hourly information?
Basically, how can tab to specific cells?

Hi Danny,
It is customary to provide sufficient information for someone to answer your question.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Danny" <Danny@discussions.microsoft.com> wrote in message news:96B90766-9BEF-4123-95CC-14CBF698549B@microsoft.com...
> We use an Excel spreadsheet to keep generation and lake elevations where I
> work.
> At 07:00 and 19:00 we have to enter in extra information.
> How can I set the sheet up so that at those hours we can tab directly to
> those cells after entering our regular hourly information?
> Basically, how can tab to specific cells?
>

Ok, I will try to explain better.
On our sheet, at 07:00, we input information in cells, 20B,20C,20E,20F &
20H. We tab to each cell and all locked cells are skipped. What we would like
to do is, after we put information in cell 20H, we would like to be able to
tab to cells, 27N, 27O, 27P, and 34M and then back to 21B. Is this possible?

"David McRitchie" wrote:

> Hi Danny,
> It is customary to provide sufficient information for someone to answer your question.
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Danny" <Danny@discussions.microsoft.com> wrote in message news:96B90766-9BEF-4123-95CC-14CBF698549B@microsoft.com...
> > We use an Excel spreadsheet to keep generation and lake elevations where I
> > work.
> > At 07:00 and 19:00 we have to enter in extra information.
> > How can I set the sheet up so that at those hours we can tab directly to
> > those cells after entering our regular hourly information?
> > Basically, how can tab to specific cells?
> >
>
>
>

Hi Danny,
Assuming the time in Column A, you can check Column A to
see if it is 7:00 or 17:00 then check where you do not want to
land and a different set if not 7:00 or 17:00 if you can modify the
example at http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc
see if you can rework it yourself. If I don't see an answer from you
i'll look at it in about twelve hours.I

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Danny" <Danny@discussions.microsoft.com> wrote in message news:4DFF30E5-794F-4E0D-B6F9-BC43690C0154@microsoft.com...
> Ok, I will try to explain better.
> On our sheet, at 07:00, we input information in cells, 20B,20C,20E,20F &
> 20H. We tab to each cell and all locked cells are skipped. What we would like
> to do is, after we put information in cell 20H, we would like to be able to
> tab to cells, 27N, 27O, 27P, and 34M and then back to 21B. Is this possible?
>
> "David McRitchie" wrote:
>
> > Hi Danny,
> > It is customary to provide sufficient information for someone to answer your question.
> >
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Danny" <Danny@discussions.microsoft.com> wrote in message news:96B90766-9BEF-4123-95CC-14CBF698549B@microsoft.com...
> > > We use an Excel spreadsheet to keep generation and lake elevations where I
> > > work.
> > > At 07:00 and 19:00 we have to enter in extra information.
> > > How can I set the sheet up so that at those hours we can tab directly to
> > > those cells after entering our regular hourly information?
> > > Basically, how can tab to specific cells?
> > >
> >
> >
> >

Hi Danny,
I did not notice last night that you had protected cells to cover most
of the tabbing, but what is row 27 that you are entering numbers into, are they
actually Maximum/Minimums., can they simply be calculated.

Is column B where you enter the hour or is the hour already filled in
from a template. Besides after entry into cell H20 are there other
cells that you go to N27 from like perhaps only cell H10
The letters come before numbers for cell addresses so I had not
noticed the change of row numbers in your description..

Since you do something different at 9:00 and 17:00 your description is
a bit vague could you send me what the sheet looks like before you
start entering daily figures and another sheet after entering 9:00 figures
and after entering 17:00 figures

Navigation can be provided by the following or combinations of
1) locked cells
2) Selections need not be contiguous or in order
B20, C20, E20, F20, H20, N27, O27, P27, m34, B21
Problem is if you break the selection by not tabbing to the next cell in selection.
3) Event macro to guide you after change Event or after a selection Change event.

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Danny" <Danny@discussions.microsoft.com> wrote in message news:4DFF30E5-794F-4E0D-B6F9-BC43690C0154@microsoft.com...
> Ok, I will try to explain better.
> On our sheet, at 07:00, we input information in cells, 20B,20C,20E,20F &
> 20H. We tab to each cell and all locked cells are skipped. What we would like
> to do is, after we put information in cell 20H, we would like to be able to
> tab to cells, 27N, 27O, 27P, and 34M and then back to 21B. Is this possible?
>
> "David McRitchie" wrote:
>
> > Hi Danny,
> > It is customary to provide sufficient information for someone to answer your question.
> >
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Danny" <Danny@discussions.microsoft.com> wrote in message news:96B90766-9BEF-4123-95CC-14CBF698549B@microsoft.com...
> > > We use an Excel spreadsheet to keep generation and lake elevations where I
> > > work.
> > > At 07:00 and 19:00 we have to enter in extra information.
> > > How can I set the sheet up so that at those hours we can tab directly to
> > > those cells after entering our regular hourly information?
> > > Basically, how can tab to specific cells?
> > >
> >
> >
> >

I have sent you a copy of our work sheet. Maybe you will be able to
understand what I am talking about if you see it. Thanks.

"David McRitchie" wrote:

> Hi Danny,
> I did not notice last night that you had protected cells to cover most
> of the tabbing, but what is row 27 that you are entering numbers into, are they
> actually Maximum/Minimums., can they simply be calculated.
>
> Is column B where you enter the hour or is the hour already filled in
> from a template. Besides after entry into cell H20 are there other
> cells that you go to N27 from like perhaps only cell H10
> The letters come before numbers for cell addresses so I had not
> noticed the change of row numbers in your description..
>
> Since you do something different at 9:00 and 17:00 your description is
> a bit vague could you send me what the sheet looks like before you
> start entering daily figures and another sheet after entering 9:00 figures
> and after entering 17:00 figures
>
> Navigation can be provided by the following or combinations of
> 1) locked cells
> 2) Selections need not be contiguous or in order
> B20, C20, E20, F20, H20, N27, O27, P27, m34, B21
> Problem is if you break the selection by not tabbing to the next cell in selection.
> 3) Event macro to guide you after change Event or after a selection Change event.
>
> --
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Danny" <Danny@discussions.microsoft.com> wrote in message news:4DFF30E5-794F-4E0D-B6F9-BC43690C0154@microsoft.com...
> > Ok, I will try to explain better.
> > On our sheet, at 07:00, we input information in cells, 20B,20C,20E,20F &
> > 20H. We tab to each cell and all locked cells are skipped. What we would like
> > to do is, after we put information in cell 20H, we would like to be able to
> > tab to cells, 27N, 27O, 27P, and 34M and then back to 21B. Is this possible?
> >
> > "David McRitchie" wrote:
> >
> > > Hi Danny,
> > > It is customary to provide sufficient information for someone to answer your question.
> > >
> > > ---
> > > HTH,
> > > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> > >
> > > "Danny" <Danny@discussions.microsoft.com> wrote in message news:96B90766-9BEF-4123-95CC-14CBF698549B@microsoft.com...
> > > > We use an Excel spreadsheet to keep generation and lake elevations where I
> > > > work.
> > > > At 07:00 and 19:00 we have to enter in extra information.
> > > > How can I set the sheet up so that at those hours we can tab directly to
> > > > those cells after entering our regular hourly information?
> > > > Basically, how can tab to specific cells?
> > > >
> > >
> > >
> > >
>
>
>

Danny,

Did you ever figure out how to do this? If so - please clue me in! Thanks

"Danny" wrote:

> We use an Excel spreadsheet to keep generation and lake elevations where I
> work.
> At 07:00 and 19:00 we have to enter in extra information.
> How can I set the sheet up so that at those hours we can tab directly to
> those cells after entering our regular hourly information?
> Basically, how can tab to specific cells?
>