data table too long to setup

R

rumkus

Hi All

This company sells tickets to people who stays in hotels for activities
they organise.
I have already prepared tables to get data for sale sheet ie user will
enter ticket number,
Activity name,activity date,hotel name, client name ,room number,number
of people.
All other information will be picked up from pre-set tables.So far no
problem except
They sale nearly 40 different activities and their clients stay in
nearly 50 hotels- if not
More than that-
And my pick-up table which consists of " activity name" , "hotel
name ", "pick-up time",
"pick- point " has 40 x 50 = 2000 row (approx).
I can let users copy/paste 1 ( activity ) x 50 ( hotel name ) set to
change only activity name later on ofcourse.But.
I just wonder if you people encounter such discussion.Can you direct me
if possible.

Thank you very much.
 
Top