Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Create Filter Calendar based on two options to one page

0

Hi,

I am looking to create an EXCEL doc that can gather the data found on sheets 2-13 based on how the person filters the 2 categories on page 1. Using certain brands and locations as the categories.

So if I choose brand A and location C, all information pertaining to those two categories is pulled from the calendar months and summarized on the main page and so on and so forth. I know how to create filters/drop downs but do not know the formula to pull the data from the "data calendar sheets" and summarize to main page.

Thanks, R

excelformulas-functionssort-filter
MS Office Version: Rosanam1286
posted by: Rosanam1286 on Tue Aug 29, 2017 at 5:43 pm
Answer
Discuss

Answers

0

Why not just link all of the data from the data worksheets to the summary worksheet so that all of the data appears on the summary worksheet and then filter the data on the summary worksheet?

Something like: =Sheet1!A1 and then copy the formulas down until all of the data appears in the summary sheet.

posted by: don (rep: 1989) on Tue Aug 29, 2017 at 6:28 pm
Discuss
0

It's not clear what you want. Perhaps a formula like this one might help.

= SUM ('Sheet2:Sheet13'!A1)

This formula would sum up the values in cells A1 from Sheet1 to Sheet13, including all sheets between them. Use the names you have given to the sheets as displayed on the tabs.

posted by: Variatus (rep: 4889) on Tue Aug 29, 2017 at 9:19 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login