LinkBack URL
About LinkBacks
Good morning everybody!
I am wondering if anyone can help me on how extract the row based on specific criteria.
For example, on the attached sample worksheet. I want all ID 5 listed on Sheet 4 with all Lore (5) from each sheet. Thanks in advance!
Extract rows based on criteria
Good morning everybody!
I am wondering if anyone can help me on how extract the row based on specific criteria.
For example, on the attached sample worksheet. I want all ID 5 listed on Sheet 4 with all Lore (5) from each sheet. Thanks in advance!
how many times will lore be listed on any particular sheet?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Re: Extract rows based on criteria
It should be listed 3 of Lore''s record rows each from sheet 1, 2, 3, thats what I meant.Originally Posted by martindwilson
Last edited by gkeith; 07-30-2010 at 09:25 AM. Reason: more clarify
in it's simplest format
It worked for my sample, but when I tried my actual worksheet, it is not seemed to be working. :-/
Is there any way I can "copy" row from each sheet based on criteria and paste them as list on new sheet to make Lore's "performance report" sheet?
if it works on your sample it must work on your work sheet unles they are different!
It did worked! I was missing something, but now everything's fixed. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks