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>
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>