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

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