Forum

Macro to extract it...
 
Notifications
Clear all

Macro to extract items based on amount

2 Posts
2 Users
0 Reactions
88 Views
(@howardc)
Posts: 54
Trusted Member
Topic starter
 

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)

 
Posted : 20/08/2021 12:57 pm
(@catalinb)
Posts: 1937
Member Admin
 

Was answered already on the other forum.

 
Posted : 21/08/2021 1:15 am
Share: