Copy data to another sheet based on supplier number and given dates

FarideAb 0
Viewed 15

I have an Excel sheet that currently looks something like this:

enter image description here

I'd like to enter a supplier number and a date range in a sheet (example below) and that the data that fulfills the criteria is copied to a new sheet

enter image description here

So let's say, I enter supplier number "00X12345" and From 23/08/2022 to 27/08/2022, so it'd copy this data:

enter image description here

Does anyone know if this would be possible using VBA?

vba excel
0 Answers
Related