Lookup and Return

B

badpuppie

I have a workbook with several worksheets in it. If column D of eac
worksheet has a variable I'm looking for I want the entire row that ha
that variable to appear in a new sheet. If every worksheet has a few
I'd somehow like the new sheet to contain all the rows, stacked on to
of each other
 
B

Bernie Deitrick

bad,

How do you feel about using a macro? That would be fairly easy if your
workbook has sheets with similar structure.

HTH,
Bernie
MS Excel MVP
 
Top