Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

NEED LOOK FOR NUM

NEED TO LOOK FOR NUM IN LOCATION 12 AND 13

NEED TO CREATE PREVIEW WITH THE OCURENCES

NEED TO CREATE 2 PREVIEW ONE FOR LOCATION 12 NUM AND OTHER FOR LOCATION 13

LIKE THE SAMPLE HERE
LOOKFORNUMDATA.xlsx
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

NEED TO CREATE 2 PREVIEW ONE FOR LOCATION 12 NUM AND OTHER FOR LOCATION 13
I'm not sure what that means. Do you want two Preview sheets or just one?
Avatar of ADRIANA P

ASKER

Martin Thanks !!!

two buttoms
need 2 sheet one for each location 12 and 13 with the ocurrences
Do the numbers occur in column "G"? Do you want to look for the exact number?
Martin  have to be the exact number

column G is the occur
I was playing around with a macro that was made for you before but I am not sure if this is what you want. All I did was create 2 buttons 12 and 13.... that will filter on either of those... but since I am not a VBA expert getting it to unfilter is another question. You will just have to manually do it for now. :)
EE---LOOKFORNUMDATA.xlsm
I think Martin is the expert in that area.
Thanks Edward Pamias    how are you doing !!

thanks for you help !!

this situation have to be done with VBA  good friend
is a  lot of  data to be done
manually wont' help me
Marttin almost good

need  2 adjustments


1-need the column J  be show in the preview (ord)
the other adjustme
2- need  the set  that have the num select  be show
2- need  the set  that have the num select  be show
I don't understand what that means. Please show me an example.
User generated image
It is already doing this. Is that what you mean?
User generated image
User generated image
Martin Column J have to be show
the numbers where the call number is pull ( THE SET OF 13 row)have to be show
working great !! i did an little error
i need add an counter in column H for count the possitions 12 and 13  repeat

it will be pull too ??
Try it and see:)
ok
Working !! Great !
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great ! JOB !!

Working as Needed !!