Excel Data Entry / Reference Question: Approach?

Good morning/afternoon all, and thanks in advance for
taking the time to help me out,

Basically, I'm looking for the most reasonable way to
approach a project my boss and I have attempted to set up
several times, only to fail.

Task: We want to arrange non-linear data "linearly," as
in, take data that does not fall into rows being dumped
into rows somehow (perhaps on another sheet) then sorted
by particular items in that row, for viewing.

For example, we want to enter values like "Name,
Location, Date Started, Sq. Ft., Final Value ..." In a
small "form box" that would take up several rows and
colums, then have that data dump into some database that
we could access by those categories, for example, pulling
all jobs with a sq. ft. value of 500, an no other jobs.

Is there any sort of approach that would work best in
this situation? I am mildly experience in VB forms and
could use them to some extent if necessary.

Any ideas would be greatly appreciated, as I'd like to
shop for one i'd feel most comfortable working with.
Thanks again, my faithful counterparts.

-Steve Carpineta, Matco Electric Corp., Vestal, NY

Guys,

I've determined that i'll use the Data Form function to
keep the list, however, is there any way to set up how
the information will be displayed on the form? For
instance, if i want to assign four values to be near each
other, but on the other side of the form as some other
values, can i set those settings?


Thanks again,

Steve

-----Original Message-----
Good morning/afternoon all, and thanks in advance for
taking the time to help me out,

Basically, I'm looking for the most reasonable way to
approach a project my boss and I have attempted to set
up
several times, only to fail.

Task: We want to arrange non-linear data "linearly," as
in, take data that does not fall into rows being dumped
into rows somehow (perhaps on another sheet) then sorted
by particular items in that row, for viewing.

For example, we want to enter values like "Name,
Location, Date Started, Sq. Ft., Final Value ..." In a
small "form box" that would take up several rows and
colums, then have that data dump into some database that
we could access by those categories, for example,
pulling
all jobs with a sq. ft. value of 500, an no other jobs.

Is there any sort of approach that would work best in
this situation? I am mildly experience in VB forms and
could use them to some extent if necessary.

Any ideas would be greatly appreciated, as I'd like to
shop for one i'd feel most comfortable working with.
Thanks again, my faithful counterparts.

-Steve Carpineta, Matco Electric Corp., Vestal, NY
.