L
Ltat42a
Hi All,
I made a spreadsheet to inventory and test hose. I have one workshee
that has the entire inventory on it, another that lists test result
for this hose. Hose is required to be tested annually. I made two use
input forms to enter the information into the worksheets. Hose section
will have a unique ID number, location, date that the hose was put int
service, and length of hose.
Hose is purchased, stored in the warehouse. When needed, one (o
more)section(s) of hose maybe issued to one of 30 different companies
Once it is issued, that company is responsible for testing the hose
then, report those results back to me.
I'm looking to create a report for each of the 30 companies from th
data that I have in the Test Results worksheet. None of the data wil
be sorted,
test results will be entered randomly as I receive the results.
Conversely, I need a report of what I have available in the warehouse.
I need to know what hose has been tested, what hose hasn't.
What the best method to create these reports?
Thanx
I made a spreadsheet to inventory and test hose. I have one workshee
that has the entire inventory on it, another that lists test result
for this hose. Hose is required to be tested annually. I made two use
input forms to enter the information into the worksheets. Hose section
will have a unique ID number, location, date that the hose was put int
service, and length of hose.
Hose is purchased, stored in the warehouse. When needed, one (o
more)section(s) of hose maybe issued to one of 30 different companies
Once it is issued, that company is responsible for testing the hose
then, report those results back to me.
I'm looking to create a report for each of the 30 companies from th
data that I have in the Test Results worksheet. None of the data wil
be sorted,
test results will be entered randomly as I receive the results.
Conversely, I need a report of what I have available in the warehouse.
I need to know what hose has been tested, what hose hasn't.
What the best method to create these reports?
Thanx