filter data from 10+workbooks and display in separate workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several workbooks to maintain and I want to be able to gather
information from all of them and filter them by different criteria. For
example, searching through all the workbooks, display only the rows that
contain the word "Item".

Is this possible? and How?
 
You must log in or register to reply here.

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

summarizing data from various workbooks 3
Macro to push data to another workbook 0
Single Filter to change all Pivot Tables in a Workbook 8
Linking multiple worksheets in one workbook 2
Password / Filter workbook by user 1
linking many workbooks 6
Filters and subtotals 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top