Auto build report
 

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

Auto build report
 

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