#1   Report Post  
Beantown20
 
Posts: n/a
Default Navagating issue


When entering an amount in lets say cell A5 I want to goto B15 after I
hit enter. Is this possible


--
Beantown20
  #2   Report Post  
Ashish Mathur
 
Posts: n/a
Default Navagating issue

Hi,

Select the cells in the order in which you want to navigate and then go thje
name box on the top left corner and give it some name.

Next when you want to navigate through those specific cells type the name
inthe name box and those cells get highlighted. You can then move to those
cells by hitting enter ot tab

Regards,

Ashish Mathur

"Beantown20" wrote:


When entering an amount in lets say cell A5 I want to goto B15 after I
hit enter. Is this possible


--
Beantown20

  #3   Report Post  
Beantown20
 
Posts: n/a
Default Navagating issue


ok stupid question. How do i go about selecting the cells. Do I put
comas between the cells which does highlight them (=+B4,B6,B8,B10) but
I get a value error in that cell. Sounds very simple when you explain
it so I am probibly making this harder than it is. Any help would be
greatly appreciated.

Bean

Ashish Mathur Wrote:
Hi,

Select the cells in the order in which you want to navigate and then go
thje
name box on the top left corner and give it some name.

Next when you want to navigate through those specific cells type the
name
inthe name box and those cells get highlighted. You can then move to
those
cells by hitting enter ot tab

Regards,

Ashish Mathur

"Beantown20" wrote:


When entering an amount in lets say cell A5 I want to goto B15 after
I
hit enter. Is this possible


--
Beantown20



--
Beantown20
Reply
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
Another rounding issue Biff Excel Worksheet Functions 2 June 20th 05 01:10 PM
Sorting Issue (Mixde Fields) Jonathan G. Excel Discussion (Misc queries) 1 May 11th 05 03:54 PM
An issue when sorting in excel PivotTable Microlong Excel Discussion (Misc queries) 0 May 10th 05 09:50 AM
New Excel Comment Box Issue elai Excel Discussion (Misc queries) 3 February 23rd 05 01:09 AM
Shared File & Freeze panes issue JM Excel Discussion (Misc queries) 0 January 21st 05 07:01 PM


All times are GMT +1. The time now is 03:52 AM.

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"