Auto build report

N

Nadine

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average cells based on column header 6
MACRO Problem 1
copy/paste row with one formula 6
Having Blank Cells, etc. ? 1
Function to move data 1
Macro Code 4
Excel Help to copy information from one row at a time to another sheet 1
Rank based on 2 categories 6

Top