Adv Filter Budget
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Adv Filter Budget as PDF for free.
More details
- Words: 229
- Pages: 4
Total 2003 Month Jan-03 Jan-03 Jan-03 Jan-03 Feb-03 Feb-03 Feb-03 Feb-03 Mar-03 Mar-03 Mar-03 Mar-03
Sales
# Product 001 Product1 002 Product2 003 Product3 004 Product4 001 Product1 002 Product2 003 Product3 004 Product4 001 Product1 002 Product2 003 Product3 004 Product4
15,920
Sales Budget Actual 1,200 1,000 2,000 1,800 3,000 2,200 100 60 1,500 1,200 3,000 2,800 1,000 1,200 1,000 600 1,400 1,000 2,200 1,800 2,500 2,200 300 60
Revenue
2,520
Expenses Budget Actual 900 700 1,500 1,300 2,100 2,200 70 50 1,000 900 2,500 2,300 1,100 1,200 700 500 900 700 1,500 1,300 2,100 2,200 70 50
Select a month, or Total 2003, from the dropdown list in cell A2. Data Validation was used to create this list. An Advanced Filter shows the items for the selected month. The Subtotal function is used in row3, to calculate the total sales and expenses, and calculate the revenue. To view the code that runs the filter, rightclick the sheet tab, and choose View Code.
003, from the Data Validation was the items for the
sed in row3, to nd expenses, and
s the filter, righthoose View Code.
Total 2003 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03
Month
This is the criteria range for the Advanced Filter
This range is named MonthList and is the source for the data validation dropdown on the Master sheet
Sales
# Product 001 Product1 002 Product2 003 Product3 004 Product4 001 Product1 002 Product2 003 Product3 004 Product4 001 Product1 002 Product2 003 Product3 004 Product4
15,920
Sales Budget Actual 1,200 1,000 2,000 1,800 3,000 2,200 100 60 1,500 1,200 3,000 2,800 1,000 1,200 1,000 600 1,400 1,000 2,200 1,800 2,500 2,200 300 60
Revenue
2,520
Expenses Budget Actual 900 700 1,500 1,300 2,100 2,200 70 50 1,000 900 2,500 2,300 1,100 1,200 700 500 900 700 1,500 1,300 2,100 2,200 70 50
Select a month, or Total 2003, from the dropdown list in cell A2. Data Validation was used to create this list. An Advanced Filter shows the items for the selected month. The Subtotal function is used in row3, to calculate the total sales and expenses, and calculate the revenue. To view the code that runs the filter, rightclick the sheet tab, and choose View Code.
003, from the Data Validation was the items for the
sed in row3, to nd expenses, and
s the filter, righthoose View Code.
Total 2003 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03
Month
This is the criteria range for the Advanced Filter
This range is named MonthList and is the source for the data validation dropdown on the Master sheet
Related Documents
Adv Filter Budget
November 2019 12
Adv Filter Search Word
November 2019 13
Filter Adv Criteria
November 2019 19
Adv Filter City
November 2019 7
Adv Filter Rep Filtered
November 2019 11