Filtering Data Based on Date Value in Cell and compile the Data for Analysis

Dear Experts,

Attached Excel Contains two Worksheets; User_Menu, Demand_Input Basically, this excel file will be loaded with demand visibility from customer on daily basis!

Demand_Input:-

Ref. Date is a Date Reference on that day what was the demand available in system.

Sequence, Category, CRD Months, A1, Sales Order, Line No, Customers Standard Fields.

FG Part Number is a Product, CRD Qty is a respective customer requested quantity & CRDGI Date is the Customer Requested Date

User_Menu:

There is a two Field mentioned as From and To, The user will have an option to key two different date for which the demand Variation to be calculated

Here In this Case; I would like to compare the data between 03 Jun 2019 Vs. 06 Jun 2019!

The Support Which I am Looking here is: -

Your suggested VBA expected to follow below sequence!

User Menu To Field Mentioned Date (Here it is 06 Jun 2019) to be filtered in “Demand_Input” Worksheet Column A i.e. Ref. Date.

The Filtered Value (Visible Cells Only) To be copied (Including Heading) and a New worksheet to be created and Renamed as comparison Between UserMenu To Date Vs. From Date (Inthis Case the Newly Created worksheet must be renamed as “Comparison B/W 06 Jun 2019 vs. 03 Jun 2019”).

The Copied Values to be paste special Values as is from A1 Cell.

Now, User_Menu From Field Mentioned Date (Here it is 03 Jun 2019) to be filtered in “Demand_Input” worksheet Column A i.e. Ref. Date.

The Filtered Value (Visible Cells Only) To be Copied without heading and paste below last blank Row in “Comparison B/W 06 Jun 2019 vs. 03 Jun 2019” worksheet

(Note While pasting From Date; All 03 Jun 2019 CRD Qty alone to be multiplied with -1)

Looking forward your valuable suggestion to meet this Requirement!

Thanks & Regards,
Rajeshkumar R