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

asked on

LOOK FOR

Need to look for in column coulmn G

and create preview with 6 sets that follow
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

here the file sorry !
datedta.xlsx
Avatar of Edward Pamias
Hello Adriana, what are we looking for in Column g?
Hi !  Edward Pamias need to look for the data in column G
Not a lot of information to go on, but try this.
29024006.xlsm
Martin ! Working Great !that's what i need !

but need have  6 buttoms  to call 6 coulmns to compare in the same prewview sheet
because data can have different dates in
Edward Pamias  thanks Good friend !  you always  helping !!
but need have  6 buttoms  to call 6 coulmns to compare in the same prewview sheet
That's the kind of information you should include in the original question.

Please supply a workbook that has at least two columns.
Martin the data will come out from the same column G
but with 5 more buttoms to ask diferents dates
as needed
Also do you really need 6 buttons? How about just one that asks you which column you want to look in? (It would man answering 2 questions - the column letter and the date rather than clicking just answering one question like it does now.
Well will not work
because I need pull the data from the same column G as you did

but for  example

i need pull  30W2016  and    39W2016  and    43W2016   and create one column of eachone  in the preview sheet
I see I like great !!

but need it User generated image
i need call diferrents dates of data and have near each one   in the preview sheet
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
User generated image
Martin i get this  when i  open the woorbook
Delete this line

Set colMatches = Nothing
I delete as you say but
 i get it now
 User generated image
MARTIN iS WORKING ! GREAT ! SORRY BECAUSE I GET LOST BUT I TRY AND YOU RIGTH !
THANKS !!
gREAT jOB LIKE ALWAYS !!!