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: 2
Default Control Data Entry - push entry to next cell

Good morning!

I have created a spreadsheet with three columns. Col A is Tally#. It is an
autonumber 1-200. Column B is Length. The data for Length is not entered
using the keyboard. It is entered via blue-tooth from a laser distance
meter. Column C is a running total. I have protected Column A and Column C.
I would like for the user to enter his or her data via blue tooth onto B.
Validation is done and working. My problem and or question is Column B. I
would like to have the active cell start on B6 and for the user to start
beaming numbers. I would like for Excel to start moving the active cell down
to keep entering data. However, if the user accidentally clicks on a cell
above or below the current cell then, I want to beep him with a messagea
saying "this sell contains information". We need to be careful not to over
write data unless we need to change and it is important that we do not skp
cells. Thank you!

I apologize if this is confusing.
--
Ofelia
 
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
restricting entry into a cell based on entry to a previous cell newbie57 New Users to Excel 1 June 9th 08 05:43 PM
Auto entry of data based on entry of text in another column or fie Judy Rose Excel Discussion (Misc queries) 2 May 21st 08 01:14 PM
Can I control entry into certain tabs? OrlaLynch Excel Discussion (Misc queries) 4 April 29th 08 06:24 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing [email protected] Excel Discussion (Misc queries) 0 March 20th 08 12:45 PM
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 09:52 PM


All times are GMT +1. The time now is 08:19 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"