#1   Report Post  
andym
 
Posts: n/a
Default 2 questions

hi,

can I use a barcode scanner with excel to enter in data?

Failing that is this possible in excel - have 300 items (people),
enter some of their numbers in a box at the same time e.g 5,99,24,56
this would then enter the current time into a field on each of their
rows?

Is this to much for excel or am I looking at access?

Basically we are having a 24hr bike race for charity, each team/person
would do a lap, so need start, stop and lap counter data.

thanks
andym
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Andy,
A barcode scanner is essentially a keyboard.
so the answer is yes it can be used to enter data into Excel.

I don't think you're going to obtain stop watch accuracy from
direct entry even without the scanner, if you were to hit only
one key per 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

"andym" wrote in message m...
hi,

can I use a barcode scanner with excel to enter in data?

Failing that is this possible in excel - have 300 items (people),
enter some of their numbers in a box at the same time e.g 5,99,24,56
this would then enter the current time into a field on each of their
rows?

Is this to much for excel or am I looking at access?

Basically we are having a 24hr bike race for charity, each team/person
would do a lap, so need start, stop and lap counter data.

thanks
andym



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
what book do you recomende for formulas & advance excel questions KimSingh Excel Discussion (Misc queries) 1 April 3rd 05 10:46 AM
Questions about MS Word [email protected] Excel Discussion (Misc queries) 5 January 13th 05 03:49 AM
A few VBA questions - long post! Fiona O'Grady Excel Discussion (Misc queries) 5 December 19th 04 04:12 PM
Query questions (I think) Brian Excel Worksheet Functions 4 December 13th 04 03:53 PM
2 Questions Beth Excel Worksheet Functions 3 December 1st 04 06:01 PM


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