filter data based on a starting day and ending day

[stevetodd400243]

Hello,
The attached file request was provided to me on this forum and is working as I first described it. However I would like the filter option to be on the main sheet. "DATA", no need to have the table2 sheet any longer.
When a user enters a starting Date in cell B1, and an ending date in Cell D1 then clicks an added refresh button, only rows with a Ship Date between the start date and end date would be shown. Thanks for all help provided.

 

[vletm]

stevetodd400243
You've opened this thread to Ask an Excel Question but
Your thread's title gives image that this belongs to Power BI, Power Query and Power Pivot.
Please reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Please post, new posts in the correct forums
This thread is moved to forum based Your Thread's title.

 

[stevetodd400243]

stevetodd400243
You've opened this thread to Ask an Excel Question but

This thread is moved to forum based Your Thread's title.

Thank You for the correction Vletm, My apologies for the mixup.

 

[p45cal]

@vletm , this has come away from being a Power Query problem since the OP only wants a table filtered in situ.
@stevetodd400243 ,a one-line macro will do this; it's run by clicking button at cell F1.

 

[stevetodd400243]

p45cal, thank you! didn't think it could be accomplished with just a one line Macro. Appreciate it.