LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 170
Default Control IP movement

Am designing a spreadsheet template to consolidate daily operations
information into a one page report. Have tried using Word forms with fields
which does a great job of controlling the order of the data entry when
locked, however in Word2000 generating calculations is frustrating in a
locked form.

In Excel, here is my stumbling block. I need to automate movement from cell
to cell, cells for data entry are not lined up continously. Is there a
simple method of positioning insertion point in cell G5, then moving to cell
K3 after data is entered into G5, and so forth?

I have approximately 50 cells for data entry in this little spreadsheet. Any
pointers will be greatly appreciated.

Help will be graciously appreciated.
 
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
Problem with control tag and populating speadsheet antonsaitz Excel Discussion (Misc queries) 0 June 30th 06 04:29 PM
ActiveX control with chart Tanihera Charts and Charting in Excel 1 April 11th 06 05:36 PM
How to insert date using a pop up calendar control in a cell i Iain the scout Excel Discussion (Misc queries) 4 December 17th 05 08:10 PM
How can I control cell movement with the Tab key? Bojo Excel Discussion (Misc queries) 4 September 3rd 05 01:16 AM
Copying list-box control Excel Discussion (Misc queries) 1 January 6th 05 01:39 AM


All times are GMT +1. The time now is 02:30 AM.

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

About Us

"It's about Microsoft Excel"