Query for num3 all
need look for column F location 1 set of 13 to show column L column M and column N
n3PAL_1.xlsx
n3PAL_1.xlsx
Martin Liss
You should really post an xlsm workbook that has similar code to what you need so that someone can modify it, rather than forcing them to start from scratch.
ASKER
ASKER
but for num 2 all i will need at leat 2 buttons
1 for 3 num and and for 2 num query
for example
num query 351 need an query for 351
and other for 35
1 for 3 num and and for 2 num query
for example
num query 351 need an query for 351
and other for 35
The workbook you posted searches column "F" already. It gives you columns LMN plus some others. Are the extra columns a problem?
ASKER
Martin Liss
The workbook you posted searches column "F" already. It gives you columns LMN plus some others. Are the extra columns a problem?
Not
The workbook you posted searches column "F" already. It gives you columns LMN plus some others. Are the extra columns a problem?
Not
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Martin Liss
Thanks !! They are not an problem to me
but with just column L MN is better and more clear the visual area to better work with
one adjustmente needed when show column N can be to like here
to all sheets show after the look for
Thanks !! They are not an problem to me
but with just column L MN is better and more clear the visual area to better work with
one adjustmente needed when show column N can be to like here
to all sheets show after the look for
Just change the column width of column "N" on the DTA2N sheet to what you want it to be.
ASKER
Great Job ! Great Expert !!