
Howard Cohen
Member
Members

Forum Posts: 56
Member Since:
December 8, 2016
December 8, 2016

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)
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Ruth Savage, Srikanth Amudhan, Lorna Henning
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
