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
 

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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Needs help combining functions. 3
What is the best way to lookup from another worksheet? 0
vertical and horizontal lookup? 1
Copy entire row from another sheet onto first sheet if a unique text matches 1
Custom Autonumber with Prefix and Category Grouping 3
Lookup functions always return n/a ??? 3
search function 2

Top