MS Excel 2003 and OpenOffice Spreadsheet
 

Hello all,
First time on these forums. I need to accomplish this:
Design a form on a spreadsheet with which within seconds one can choos
from appropriate drop down lists things like gender, age, income
questions, results etc of walk-in customers

on this architectu
MS Excel 2003 on XP Home networked with
OpenOffice Calc (latest version)

to serve this purpose:
Collect data and examine it to check efficiency of marketing an
personel.

The data will be stored in the original Excel sheet as well. I a
wondering how to go about it. I imagine 40-50 people per day, s
approximately 1500 per month. At this rate, this will be a pretty hug
Excel file. Do you recommend I maintain 'monthly files'?

OpenOffice Calc is the name of the Excel equivalent of the free M
Office replacement. It is supposed to be highly compatible with Excel
Their website is http://www.openoffice.org/

I have a few examples:

GENDE
Male
Female

AG
8 - 15
16 - 20
21 - 30
31 - 40
41 - 50
50 +

TIM
10 - 12
12 - 2
2 - 4
4 - 6
6 - 8

INCOM
Low
Average
Medium
High
Very High

ARE
Neighbourhood
Near N'hood
Outside

The categories are *Bolded* and the rest are the respective drop dow
values. There will be a few more for sure. I would like the use
sitting in the front desk (who runs OpenOffice Calc) to start up he
software, open this file (mapped from the back office system runnin
excel 2003), and have a form which she continuously just chooses pr
set drop down values in pre set fields and doesnt look at the entir
spreadsheet or anything. Just streamlined near real time data entry.

I have seen some really refined excel based form based questionnaire
which is what I am looking for. I can provide detailed informatio
about the forms and the drop down lists' values etc. if somebody ca
recommend and potentially help with a solution.

Thank you.
Regards

--
abhi
-----------------------------------------------------------------------
abhic's Profile: http://www.excelforum.com/member.php...fo&userid=1639
View this thread: http://www.excelforum.com/showthread.php?threadid=27762