Explore functions like SUMIF, COUNTIF, LOOKUP, VLOOKUP
Use Excel Help to see how to use them.

RADO


"aus74" wrote in message
...

Hi

Have been given a problem here at work but have no idea where to
begin.

I have a master sheet that I need to populate with data from 5
subsidiary sheets.

Obviously all six sheets are setup in the same manner. The 5
subsidiary sheets have varying amounts of data contained within them
though (some only 10 or so lines whilst others in the hundreds).

The problem is I need some way of populating the master sheet when the
data from a certain column meets the correct criteria (i.e. contains a
"Y"). The master sheet needs to copy from all of the subsidiary sheets
all the data in any row where column contains a Y.

Is this possible? Could someone push me in the right direction?

Cheers

Aus


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/