button to selct range option in 4N WK

click the Range Pairs 3s

then have the option to
have any range as needed  show an put together in column CG
29085099a--3-_w_range_4N_t_improve.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
Try this. When you click the button you'll be asked how many range pairs you want to see. After that's done you'll see cells that looks like a button and say "Change". If you click on the "Change" cell you can ask to see however many range pairs that you want,
29085562.xlsm
1
 
Martin LissOlder than dirtCommented:
Do you mean that you want to change the number of pair ranges that are shown in column "GC"?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Do you mean that you want to change the number of pair ranges that are shown in column "GC"?

Yes to show as needed!
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Martin LissOlder than dirtCommented:
Is this for all weeks. In other words for the whole column?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

Is this for all weeks. In other words for the whole column?

Yes!
0
 
Martin LissOlder than dirtCommented:
How about this then? Currently when you click the 'Range Pairs 3s' button it assumes you want to concatenate the highest 3 pair ranges. How about if I have that button ask you how many range pairs you want to see? After that's done and you see the results, will you ever want to change just one or two of the weeks?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

How about if I have that button ask you how many range pairs you want to see?

that will be great


After that's done and you see the results, will you ever want to change just one or two of the weeks?

Martin don't understand this question !!
0
 
Martin LissOlder than dirtCommented:
Ok, you click the button and you ask to see 2 pair groups. When it's done you'll see something like this. Would you ever want to change just the result by the arrow to show 3 or 4 (or more) pair groups.
2018-02-22_16-40-49.png
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
 
Would you ever want to change just the result by the arrow to show 3 or 4 (or more) pair groups.

yes i think 3 or more as needed when needed  ( any time )
0
 
Martin LissOlder than dirtCommented:
OK.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
working as needed

Great job  Best Expert !
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.