Just checking if anyone has ideas for this. Thanks

"Nadine" wrote:

Hi,
Not sure if this is possible or not.
Tried pivot table doesn't meet needs (because how sheet is designed)
Hope can do this by formula or if can use a formula in combination with a
macro. guessing may need to create multiple hidden formula's

Each row contains specific data for a file, and want it to look up data in
specific columns/cells if matches answer, then copy data from another
cell/column and paste it into another worksheet on a new row.
Want it to look up info in i.e. if rows/Column Z has a 1 in it, then copy
the data that is in column C /matching row (column z has a score number, and
column c has the file number) want a list of file numbers that match a
specific score - Repeat same for mulitple other columns BB/AD, CC/BE, DC/CF
if possible paste the data in a specific worksheet- one record per row

Thanks