Macro to extract items based on amount|VBA & Macros|Excel Forum|My Online Training Hub

I have a sheet called "JNL Items" containing all the data

I need to extract the items from Sheet "JNL Items" on sheet "Extract Variance" based on the date range and amount in cells U2:W2

I have manually extracted the data so that you can see what items need to be extracted based on the amount in Cell W2 on sheet “extract variance”

It would be appreciated if someone could provide me with code to extract all the items pertaining to the amount in Cell W2 on sheet “extract variance

I have also posted on Macro to extract items based on amount (excelforum.com)