select data and show in other sheet ToolUP

need pick up some specific numbers

like show here



1bbbb.PNG
then move to  SELECTION sheet
b222222222.PNG

need select some data

then i put this red to knows the one need

this is an sample

can be the selected move to

an new sheet just the select??

show by column  sample fist column  then second column
29090223a--1-_SELCTOR_TOOL_BY-COLOR.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
Try this. If there are problems I won't be able to correct them for several hours.
29091748.xlsm
1
 
Martin LissOlder than dirtCommented:
Why do you need the red in columns D, F and H. Instead the code could just ask you for the the 4-digit numbers you want to count.

What does "show by column  sample fist column  then second column" mean?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Why do you need the red in columns D, F and H. Instead the code could just ask you for the the 4-digit numbers you want to count.

ok is an better way
 
but in an practical situation
i will need ask

for an  2 digit  , 3 digit  

What does "show by column  sample fist column  then second column" mean?

i refer the order  of the columns
as it appear
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
wwwwwwww.PNG
0
 
Martin LissOlder than dirtCommented:
i refer the order  of the columns
I assume you mean columns on Sheet2, but you have only one column in the SELECTION sheet, so how do I show columns in the SELECTION sheet?
0
 
Martin LissOlder than dirtCommented:
I guess a picture of what the output would look like if you looked for 68 would help.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

also i have to mention  i need to look for in the  first 4 weeks

68 can be in any position of the 4 Num

ccccccc11111.PNG

this is the output  needed

can be count ??  


343443434.PNG
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

can be an color apply by week

week 1
week 2
week 3
week 4

and be show in the SELECTION sheet
0
 
Martin LissOlder than dirtCommented:
Will you ever look for a number like 44, or 565,  or 111, or any number where more than one digit is the same as another one?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Will you ever look for a number like 44, or 565,  or 111, or any number where more than one digit is the same as another one?

yes i will
0
 
Martin LissOlder than dirtCommented:
I know that you want to see 4-digit numbers in the output, but will you ever look for 4-digit numbers?

Will you ever look 1-digit numbers?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

I know that you want to see 4-digit numbers in the output, but will you ever look for 4-digit numbers?

Will you ever look 1-digit numbers?



yes!
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job ! Best Expert
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

have an situation

because  

columns in  sheet 2 can grown or shrink as needed

some numbers have  more columns others less

the SELECTION sheet stay only in 4 columns
0
 
Martin LissOlder than dirtCommented:
I added another column in sheet2 to test with and I also put the gray color in the COUNT columns.
29091748a.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

can i use it with an 3 Num??
0
 
Martin LissOlder than dirtCommented:
I haven't tried it but you can probably do it if you remember not to look for a 4-digit number.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i get this
a1.PNG
to
0
 
Martin LissOlder than dirtCommented:
Change that line to

Dim lngRow As Long
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin!

Working great ! with that change
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.