ADRIANA P
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
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
ASKER
Martin Thanks !!!
two buttoms
need 2 sheet one for each location 12 and 13 with the ocurrences
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?
ASKER
Martin have to be the exact number
column G is the occur
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
EE---LOOKFORNUMDATA.xlsm
I think Martin is the expert in that area.
ASKER
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
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
Try this.
29021822.xlsm
29021822.xlsm
ASKER
Marttin almost good
need 2 adjustments
1-need the column J be show in the preview (ord)
need 2 adjustments
1-need the column J be show in the preview (ord)
ASKER
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
2- need the set that have the num select be showI don't understand what that means. Please show me an example.
ASKER
Martin Column J have to be show
ASKER
the numbers where the call number is pull ( THE SET OF 13 row)have to be show
An update.
29021822a.xlsm
29021822a.xlsm
ASKER
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 ??
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:)
ASKER
ok
ASKER
Working !! Great !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great ! JOB !!
Working as Needed !!
Working as Needed !!