Filter between Dates in separate sheet

Hello,

I want to filter a data set based on dates entered by the user. Then I would like to copy that data set to a new worksheet in order to do further calculations. I am not experienced in vba at all, but I understand basic programming mechanics.

I have attached a copy of the excel workbook I am working on. Below I have detailed what I am trying to accomplish. If anyone could provide some insight or a work around I would appreciate the help!

• Inventory_Status sheet is where the user will input the start and end dates
• Sheet0 is the data to be filtered. Sheet0 is updated via an automatic connection, which is not active in the attached file. A previous set of data is included on the sheet.
• The date to filter is in column A of Sheet0
• I want to create a new sheet that contains the list of data (from Sheet0) that falls between the specified dates (from Inventory_Status).
• If a new start and end date are entered is it possible to rewrite the new sheet instead of creating another one?

Thank you,
Chelsea

Bump.
Thank you.

Here's one solution,

Please Login or Register  to view this content.

Hi, i have two columns the A with NAMES and the B with DATES. I would like to give on another sheet a starting date and an ending date and to auto generate a list with all names from column NAME that the date on column DATE is between the two given dates