I have created a monster. I am creating a scheduling workbook to be used by
several people. On the first tab is a "form" that contains personal
information for each individual needing to use to transportation system.
(name, address, days needing to ride, times, emergency medical information,
etc.) This is not defined as a form in Excel standards I'm sure. It's
simply a pretty little design that I laid out. There is room to enter
information for 25 riders. What I need to do is create a database listing of
all the information for each rider on another tab so that we can use auto
filter to pull out who rides Monday on route A and who rides Monday on Route
B and so on and so on. Is there an easy way to pull this information into a
database listing? I started trying to just do the (=sheet.cell) thing and
it's going to take me forever. I'm thinking I've done this the hard way.
Any suggestions?

How is the data laid out?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TJaques" wrote in message
...
I have created a monster. I am creating a scheduling workbook to be used
by
several people. On the first tab is a "form" that contains personal
information for each individual needing to use to transportation system.
(name, address, days needing to ride, times, emergency medical
information,
etc.) This is not defined as a form in Excel standards I'm sure. It's
simply a pretty little design that I laid out. There is room to enter
information for 25 riders. What I need to do is create a database listing
of
all the information for each rider on another tab so that we can use auto
filter to pull out who rides Monday on route A and who rides Monday on
Route
B and so on and so on. Is there an easy way to pull this information into
a
database listing? I started trying to just do the (=sheet.cell) thing and
it's going to take me forever. I'm thinking I've done this the hard way.
Any suggestions?

Basically with no rhyme or reason to it except to make it look pretty. The
name is in column B4, address B6, phone B8, payment method F5, pick up time
I5, Emergency contact B16 and so on. That's for rider #1....rider #2 comes
further down the page, same columns, different rows.

"Bob Phillips" wrote:

How is the data laid out?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TJaques" wrote in message
...
I have created a monster. I am creating a scheduling workbook to be used
by
several people. On the first tab is a "form" that contains personal
information for each individual needing to use to transportation system.
(name, address, days needing to ride, times, emergency medical
information,
etc.) This is not defined as a form in Excel standards I'm sure. It's
simply a pretty little design that I laid out. There is room to enter
information for 25 riders. What I need to do is create a database listing
of
all the information for each rider on another tab so that we can use auto
filter to pull out who rides Monday on route A and who rides Monday on
Route
B and so on and so on. Is there an easy way to pull this information into
a
database listing? I started trying to just do the (=sheet.cell) thing and
it's going to take me forever. I'm thinking I've done this the hard way.
Any suggestions?

Yeah, but I need the next instance as well to construct a formula.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TJaques" wrote in message
...
Basically with no rhyme or reason to it except to make it look pretty.
The
name is in column B4, address B6, phone B8, payment method F5, pick up
time
I5, Emergency contact B16 and so on. That's for rider #1....rider #2
comes
further down the page, same columns, different rows.

"Bob Phillips" wrote:

How is the data laid out?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"TJaques" wrote in message
...
I have created a monster. I am creating a scheduling workbook to be
used
by
several people. On the first tab is a "form" that contains personal
information for each individual needing to use to transportation
system.
(name, address, days needing to ride, times, emergency medical
information,
etc.) This is not defined as a form in Excel standards I'm sure. It's
simply a pretty little design that I laid out. There is room to enter
information for 25 riders. What I need to do is create a database
listing
of
all the information for each rider on another tab so that we can use
auto
filter to pull out who rides Monday on route A and who rides Monday on
Route
B and so on and so on. Is there an easy way to pull this information
into
a
database listing? I started trying to just do the (=sheet.cell) thing
and
it's going to take me forever. I'm thinking I've done this the hard
way.
Any suggestions?

Hopefully this will help....

Rider #1
Name = b4; address = b6; phone = b8; method of payment = f5; pick up time
(home) = I5; pick up time (work) = L5; work supervisor = b10; supervisor
phone = d11; emergency contact = b16; emergency phone = j16; medical
condition = c13; special instruction = g13
Rider #2
Name = b20; address = b22; phone = b24; method of payment = f21; pick up
time (home) = I21; pick up time (work) = L21; work supervisor = b26;
supervisor phone = d27; emergency contact = b32; emergency phone = j32;
medical condition = c29; special instruction = g29

This continues down the page for at least 25 riders.
Does this help?


"Bob Phillips" wrote:

Yeah, but I need the next instance as well to construct a formula.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TJaques" wrote in message
...
Basically with no rhyme or reason to it except to make it look pretty.
The
name is in column B4, address B6, phone B8, payment method F5, pick up
time
I5, Emergency contact B16 and so on. That's for rider #1....rider #2
comes
further down the page, same columns, different rows.

"Bob Phillips" wrote:

How is the data laid out?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"TJaques" wrote in message
...
I have created a monster. I am creating a scheduling workbook to be
used
by
several people. On the first tab is a "form" that contains personal
information for each individual needing to use to transportation
system.
(name, address, days needing to ride, times, emergency medical
information,
etc.) This is not defined as a form in Excel standards I'm sure. It's
simply a pretty little design that I laid out. There is room to enter
information for 25 riders. What I need to do is create a database
listing
of
all the information for each rider on another tab so that we can use
auto
filter to pull out who rides Monday on route A and who rides Monday on
Route
B and so on and so on. Is there an easy way to pull this information
into
a
database listing? I started trying to just do the (=sheet.cell) thing
and
it's going to take me forever. I'm thinking I've done this the hard
way.
Any suggestions?