Macro to extract Data based on a value and Date Rnge

[Howardc1001]

I have data that has been imported on Sheet "Imported Data"

I have tried to amend code to extract the data on to sheet "Extract" but no data is being extracted

I need the macro to do the following:

To extract the data on to sheet "Extract" based on the folowing:


1) a date range which is inputted using a input screen in cells AA2 and AB2
2) The Total value in AC2
3) The Type in T1:T2 on Sheet "Extract"

Please Login or Register  to view this content.

I have manually extracted the data so you can see what I am trying to achieve

It would be appreciated if someone could amend my code based on my requirements

[Sintek]

You had the exact same request a while back...

[Howardc1001]

Sorry about that. I thought that the file layout was different, so did not check the old code

[Sintek]

All good...

Was actually 3 years ago...suppose code can be simplified...Anyway, Happy Coding...Tx for rep +