Questions involving filtering across multiple sheets

mattburt

New Member
Joined
Jun 18, 2008
Messages
7
I've spent about 2-3 hours trying to figure this out today but I'm just stuck. Basically I'm just trying to figure out to pull data from other sheets. So if I have a main sheet, and then 3 sheets labeled 1,2,3, the 3 sheets all have autofilters at the top. And i want to figure out how to pull data from those sheets without having to go to each one, and changing the filter each time on each sheet. The real spreadsheet I'm working on has about 50 sheets, with the main one trying to pull and filter data from all of them.

Here's a link for a example spreadsheet I made. I put my main questions in the spreadsheet. It's no where as detailed or complex as mine, but I feel if I can get a couple forumulas figured out I could apply and adapt them to the rest of the real spreadsheet.

http://www.filefactory.com/file/5f53b6/

Thanks for your help!</B>
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top