looking up a master sheet and returning positive values only

Howdy all

I want a list in a second workbook (to be issued to a contractor) to look up columns on a master list and return positive values without having to use the filtering method. Imagine if you will the master list to be a complete inventory (quite long with many blanks with the various jobs running across the sheet left to right) and the list in the second workbook to be summary of what is required for each particular job.

does anyone know the formulas etc for this or the method for achieving it?

cheers

Hello finlandstation,

Welcome to the Forum! It would be a big help it you could post a sample worksheet or example of how your data is laid out. Also which cells will be used to determine if the data is to be copied?

Sincerely,
Leith Ross

Howdy Leith

The master sheet is in this type of format


Material Job A Job B Job C


Lumber 200 x 50 6 1
300 x 50 4 2
500 x 40 3 4



The main materials list goes on for ever like this covering the building of over 30 schools being built in Papua New Guinea. Each sheet represents one school, each job being one project in that school. I can filter each column and get a material list for each job (being one building, classroom, staff room, water supply or whatever) then copy paste to a word or excel doc for the contractor. Not ideal though. I would like to have separate worksheets for each job in a separate workbook that looks up the columns of the master sheet at any time and returns just positive values as summary for the contractors.

cheers Peter

Howdy Leith

That didn't help much with the forms text formatting so I have attach a sheet from the master sheet to help explain my problem.