Excel Data Entry / Reference Question: Approach?

S

steve c matco

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top