Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filter
Have a spreadsheet, with column A: Date Column B: Daily Takings Column C:
Profit and Column D: % All data is recorded on a daily basis for every day of the financial year. A summery report for data is made on the same sheet for the total of the financial year, which is easy enough to do for the entire year. How do I filter so that only data appears in the summery report from lets say July 1 - July 21....or any other dates I choose..........ie: is it somehow possible to enter Begiining Date in a cell and End dat in another cell, so it filters the Date column and only have that dat appear in the summery report? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |