ex57.PNG

<div>
button &nbsp;select TK vertically&nbsp; from FKEYS sheet
</div>


<div>
So I assume you are talking about the &quot;Select TK Ver&quot; button on the FKeys sheet. The FKeys sheet gets created when any of the FKEYS buttons on the BYPLAY sheet is clicked. So do you want an FKEYS button added to the BYPLAY sheet for column BX? And if that is true do you want to see the same salmon/yellow coloring as the other sections?<br />
<br />
Así que supongo que estás hablando del botón &quot;Select TK Ver&quot; en la hoja de FKeys. La hoja FKeys se crea cuando se hace clic en cualquiera de los botones FKEYS en la hoja BYPLAY. Entonces, ¿desea agregar un botón FKEYS a la hoja BYPLAY para la columna BX? Y si eso es cierto, ¿desea ver el mismo color salmón / amarillo que las otras secciones?
</div>


<div>
No. This situation has nothing to do with ByPlay and is not associated with BYPLAY<br><br>but if I need to create a sheet with the result in the form of BYSET<br>as we have done before that Sheet can be called BYSETS<br>and add a selector to it as we have done before and what was selected in SELCTED<br><br><br>I need to parse column BX<br>and I am interested in doing it as the SUBFORM that appears in<br>the Select TK Vertically button by FKEYS<br><br>but in the SUBFORM you see the numbers in Horizontal form and I need that<br><br>I need to analyze them in a Horizontal way<br><br>Do you need to create a column cos the numbers in horizontal for?
</div>


<div>
The only way I'm going to have a chance at understanding what you want is if you manually create a sample BYSETS (BYSET BX?) worksheet showing me what you want.<br />
<br />
La única forma en que voy a tener la oportunidad de entender lo que quiere es si crea manualmente una muestra de hoja de trabajo BYSETS (BYSET BX?) Que me muestre lo que quiere.
</div>


<div>
I get it<br><br>Well then I will have to create a column<br><br>BX per week but horizontally<br><br>first (the same thing that I have asked you for several times)
</div>


<div>
Please then&nbsp; create &nbsp;column CB by week horizontally<br>as shows:<br><br>each week&nbsp;<br><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572177/ex58.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572177/ex58.PNG" class="fr-fic fr-dii"></a>
</div>


ex58.PNG

<div>
I have no idea why you are talking about column CB and you didn't create a worksheet like I asked you to.
</div>


<div>
yes but i have to do this first <br><br>please with button <br>to create the horizontally from BX
</div>


<div>
1- I need to analyze column BX - column BX has the pairs repeated more than 3 times a week but the information in that column is vertical<br><br>example<br><br>26W2013<br><br>have<br><br>21<br>26<br>57<br>61<br><br>(They appear because they repeat more than 3 times in the week 26W2013)<br><br>If it were to analyze them in a more practical way for me<br>it would be like this:<br><br>21265761<br><br><br>so I can compare it with other weeks that contain the same couples<br><br>If not, it will include all the repeated pairs at least the most that are repeated in order from least to greatest by pairs<br><br><br>This subform has that help that I am looking for because it allows me to see and select the most similar combinations<br><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572178/ex57.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572178/ex57.PNG" class="fr-fic fr-dii"></a><br>is the same subform use in RNUM botton in sheet1
</div>


29223939.xlsb

ACCOUNTING ASSISTANT

ADRIANA P

<div>
GreatJob !!<br>Best Expert !
</div>


<div>
<blockquote>
but if I need to create a sheet with the result in the form of BYSET<br />
as we have done before that Sheet can be called BYSETS
</blockquote>
There is no worksheet in this workbook called BYSET. What should the BYSETS worksheet look like?
</div>


<div>
i have one question needed Plaease<br><br>you have done Byset so many times....so you knows this well<br><br>can we create an subform before do the BYSETS &nbsp;<br><br>that allows me to select or enter the columns<br>I really need to select the columns that I need<br>because according to the need of the analysis the columns that I need to use may vary<br><br>if we create a form to select the columns and from there the bysets are created<br><br>it can be with a check mark or other way<br><br>do you understand me ??
</div>


<div>
It would be a subform to select the columns that I need and that will be used from the sheet sheet1
</div>


<div>
that will help me more than going to create a column by column bysets
</div>


<div>
of the sheet 1 I know which are the columns that useria and that vary would not be all but I can make a list of columns<br><br>And all I have to do is select the ones I'm going to use<br>but they are already predetermined
</div>


<div>
<blockquote>
you have done Byset so many times....so you knows this well
</blockquote>
We have done many workbooks together and I also help a lot of other people so I can't remember everything, so when the time comes that you want me to do BYSETS again you will need to refer me to a workbook where I've already done that.<br />
<br />

<blockquote>
if we create a form to select the columns...
</blockquote>
The workbook already contains the form but I need you to describe the action that will cause it to appear,
</div>


<div>
<blockquote>
of the sheet 1 I know which are the columns that useria and that vary would not be all but I can make a list of columns
</blockquote>
Did you use Google Translate to compose that sentence?
</div>


<div>
<br>From sheet 1 I know which are the columns that I would use<br><br>I can make a list of the columns<br><br>It would be defaulted to be called to create the BYSET<br><br>So it would be a matter of just putting a check mark or select them from a list and then from there the BYSET would be created
</div>


<div>
here an sample of byset<br><a href="https://www.experts-exchange.com/questions/29222829/4n-to-create-by-set-rnum-sheet.html" rel="ugc">https://www.experts-exchange.com/questions/29222829/4n-to-create-by-set-rnum-sheet.html</a>
</div>


<div>
Why are you still talking about BYSET when you asked &quot;can we create an subform before do the BYSETS&quot;? So please respond to <br />

<blockquote>
The workbook already contains the form but I need you to describe the action that will cause it to appear 
</blockquote>
</div>


<div>
here others by set sample<br><a href="https://www.experts-exchange.com/questions/29222829/4n-to-create-by-set-rnum-sheet.html" rel="ugc">https://www.experts-exchange.com/questions/29222829/4n-to-create-by-set-rnum-sheet.html</a>
</div>


<div>
<blockquote>
The workbook already contains the form but I need you to describe the action that will cause it to appear
</blockquote>
</div>


<div>
this would be like a BYSET creator at the moment according to my need for columns<br><br>really that is what I am needing because so I can analyze distant columns based on a given moment, that is, by a combination that arose<br><br>Well let's say I want to create a by sets<br><br>if we create a subform where there is a list<br><br>for instance<br><br>I have these columns available in the list (others may be available)<br><br><br>B<br>BF<br>BP<br>CB<br>AU<br>av<br>AW<br>AX<br><br>then I can select him<br><br>I want a BYSET of the columns BF CB<br><br>and then she asks me which one would be the select<br><br><br>Well, from the CB column and it shows me the list of numbers of that column and I can select CB as the Index column to make my BYSET<br>that contains the numbers according to CB that I chose<br><br>do you understand me?<br><br>Whenever a BYSET is created I have to specify which would be the Index to follow and from there she looks for the information<br>and accommodates it
</div>


<div>
<blockquote>
do you understand me?
</blockquote>
Sorry, but no.<br />
<br />
What action on your part would make the userform appear? Do you understand me when I say &quot;what action&quot;?<br />
¿Qué acción de su parte haría aparecer el formulario de usuario? ¿Me entiendes cuando digo &quot;what action&quot;?
</div>


<div>
Should that button be on Sheet1? If so what column?
</div>


<div>
here we are talking about a way where it allows me to select the columns that I want to use from a list
</div>


<div>
the list of columns comes from sheet1
</div>


<div>
so I can select coulmnas according to my need<br><br>I will not only be limited to a specific
</div>


<div>
Click the new COLUMNS button. What should happen after OK is clicked?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572278/29223996.xlsb" target="_blank" class="file-inline" title="29223996.xlsb (8.2 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29223996.xlsb</a>
</div>


29223996.xlsb

<div>
after selecting the columns<br><br>He asks me what is the column that he has<br>the index number<br>what will create the byset<br><br>a single column will be the index<br><br>and the others will be shown according to the index<br><br>and it will show the repetitions that is the index in the different sets
</div>


<div>
whenever we do a bysets we do a look up<br><br>where we tell him what is the number that defines the sets<br><br>that you have to ask them now as a second step<br>1-after the columns are selected<br>2-which will be the column that defines the lookup
</div>


<div>
In your two byset worksheets links you linked to the same workbook and there's no BYSET worksheet in that workbook.
</div>


29223939--1-.xlsb

<div>
It looks like you just now added the SETS sheet to that workbook and that doesn't do me any good since there is no code asociated with it. Please attach a new workbook with one sheet that looks k=like what you want to see in BYSETS.<br />
<br />
Parece que acaba de agregar la hoja SETS a ese libro de trabajo y eso no me hace ningún bien ya que no hay ningún código asociado con él. Adjunte un nuevo libro de trabajo con una hoja que se parezca k = a lo que desea ver en BYSETS.
</div>


<div>
the Button &nbsp; RNUM &nbsp;in column BP have already an BYSET but only for that column<br><br>
</div>


<div>
here an early byset :<a href="https://www.experts-exchange.com/questions/29022700/need-help-to-look-for.html" rel="ugc">https://www.experts-exchange.com/questions/29022700/need-help-to-look-for.html</a>
</div>


<div>
another sample in any case here :&nbsp;<a href="https://www.experts-exchange.com/questions/29021287/NEED-TO-LOOK-FOR-EXACT-NUMBER.html" rel="ugc">https://www.experts-exchange.com/questions/29021287/NEED-TO-LOOK-FOR-EXACT-NUMBER.html</a>
</div>


<div>
None of that is what I need. I previously asked you<br />

<blockquote>
What should happen after OK is clicked?
</blockquote>
 and your answer was<br />
<br />

<blockquote>
after selecting the columns<br />
<br />
He asks me what is the column that he has<br />
the index number<br />
what will create the byset<br />
<br />
a single column will be the index<br />
<br />
and the others will be shown according to the index<br />
<br />
and it will show the repetitions that is the index in the different sets
</blockquote>
which I don't understand at all, so please create a worksheet that should show up after I select for example the AX, BF and BP columns.
</div>


<div>
You are asking me something that I don't know how to do programmatically<br><br>&nbsp;I only know how to present the final information as I need it but the process that I am asking you is easy<br><br>The final result, you already know how it is.<br><br>What if I can tell you is the steps for you to do it programmatically or develop it as best you can<br><br>HERE this is BYSET<br>&nbsp;<br><a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572294/ex65.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572294/ex65.PNG" class="fr-fic fr-dii"></a><br><br><br>HERE THE LOOKUP then byset shown after i select the NUMBER from the list <br><br><a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572295/ex64.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572295/ex64.PNG" class="fr-fic fr-dii"></a><br><br>need to<br>1- create one lookup with an list of columns avaliable to mix in an BYSET ( i can use one at or 3&nbsp; at same time )<br>2-after the columns are selected &nbsp;then &nbsp;need to define wich will be the primary list so it brings to me the list to make the query<br>3-then the lookup fo the primary list is shown so i select the number<br>3- then an BYSET is create with the query from the columns i mix <br>thats all<br><br>
</div>


ex65.PNG

ex64.PNG

<div>
what I want is the same thing that is here<br><br>The only thing that is different is that at the beginning<br><br><br>sa going to develop a way (you decide)<br><br>1- where it allows me to have all the columns available that can be useful for a BYSET (I can prepare the list for you)<br><br>2-from that list I will select the columns that I want to see simultaneously<br><br>3- after selecting the ones I am going to use in that BYSET<br>auna I assign her as the LookUp (or INDEX) encragada<br><br>and the rest is equal a BYSET result
</div>


<div>
you already know how to do the BYSET<br><br>because you already have it done<br><br>what you have not done is<br><br>have a list of columns and be able to choose and define one as the one in charge of the Look Up<br><br><br><br>If you do not define one as the Look Up manager, the data cannot be called
</div>


<div>
you already know how to do the BYSET<br><br>because you already have it done<br><br>what you have not done is<br><br><br>have a list of columns and be able to choose and define one as the one in charge of the Look Up<br><br><br><br>If you do not define one as the Look Up manager, the data cannot be called<br><br>in the RNUM button the form gives me a list of numbers<br><br>I need a way like that to let me choose the Columns that I need at the same time<br><br>The idea is to be able to choose the columns that I want and not be canonized to a single column like the RNUM button that only calls a single column and does the look up and then the BYSET<br><br>the look up is the way it presents the numbers and I can choose them<br><br>the byset is what you see when you select the number from the lookup list
</div>


<div>
You the Best !! you can create that
</div>


<div>
right now RNUM I press a button<br>and I get the lookup, I select the number that filters what I want to see<br>and voila, present the BYSET<br><br>BUT<br><br>Suppose I tell you I have 10 columns all with different data<br><br>but I want to analyze 4 of those 10 columns<br><br>then I press a button<br><br>I see a subform like the one in the photo or it seems<br><br>I take those 4 columns that I want to compare<br><br>now I tell you column 3 is going to be the lookup by which the others will accommodate me<br><br>then she shows me a shape like the one in the photo<br>With the numbers in column 3 and I choose from column 3 the number that will help me filter and see the data one next to the other of distant columns in this case 4 columns that I chose<br><br>and voila, the BYSET of 4 different columns is produced but based on the query of the lookup that I select<br><br>If you notice, go through two lookups and I had to define the column that would help me filter the data of the other columns.<br><br>as i wish<br><br><br>explain me well?
</div>


<div>
I asked you to &quot;please create a worksheet that should show up after I select for example the AX, BF and BP columns&quot;. I meant for you to do that manually. The BYSET worksheet in your picture shows the selections that were made. That worksheet is similar in function to the FKEYS HOR worksheet. The worksheet I'm asking you you create would be where the BYSET selections are made from. Just like the FKEYS worksheet is where the FKEYS HOR selections are made from.<br />
<br />
Le pedí que &quot;cree una hoja de trabajo que debería aparecer después de seleccionar, por ejemplo, las columnas AX, BF y BP&quot;. Quería que lo hicieras manualmente. La hoja de trabajo BYSET en su imagen muestra las selecciones que se hicieron. Esa hoja de trabajo es similar en función a la hoja de trabajo FKEYS HOR. La hoja de trabajo que le estoy pidiendo que cree sería desde donde se hacen las selecciones de BYSET. Al igual que la hoja de trabajo FKEYS es desde donde se hacen las selecciones de FKEYS HOR.
</div>


<div>
<blockquote>please create a worksheet that should show up after I select for example the AX, BF and BP columns".&nbsp;</blockquote><br>that's what I have explained to you<br>you can't create a Column Sheet because it would be like creating a copy of the sheet1 and that already exists<br><br>the next step has to be a SUBFORM that allows me to select the columns that are available in a list<br><br>as in the photo here but from the columns<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572310/ex57.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572310/ex57.PNG" class="fr-fic fr-dib"></a><br><br><br><br>
</div>


<div>
so I can select the columns that I want to use, it can be one or several at the same time according to my need<br><br><br>So the first step is to create a subform of the available columns that can be called to be used in the byset.
</div>


<div>
<blockquote>
you can't create a Column Sheet because it would be like creating a copy of the sheet1
</blockquote>
If I have any understanding of what you want then that's not correct. In the FKEYS sheet we don't have a copy of Sheet1, only the columns that are needed. For the sake of this discussion let's say that the new worksheet I think we need is called NWS. &nbsp;In the Columns userform you can select the columns you want to look at. Let's say you choose &quot;AU&quot;. I would then copy AU to NWS. When AU is chosen what other columns would you like to see on NWS?<br />
<br />
Si tengo algún entendimiento de lo que quieres, entonces eso no es correcto. En la hoja FKEYS no tenemos una copia de Sheet1, solo las columnas que se necesitan. Por el bien de esta discusión, digamos que la nueva hoja de trabajo que creo que necesitamos se llama NWS. En el formulario de usuario de Columnas, puede seleccionar las columnas que desea ver. Digamos que elige &quot;AU&quot;. Luego copiaría AU a NWS. Cuando se elige AU, ¿qué otras columnas le gustaría ver en NWS?
</div>


<div>
<br><br><br><blockquote>what other columns would you like to see on NWS?</blockquote><br>All the columns that you have data are necessary for me<br><br>that's why I would be interested in doing this like this to make combinations<br><br>that I can't right now<br><br>the columns that are counters do not work for me<br>so for example columns will be ok<br><br>B<br>Q<br>BF<br>CB<br>CI<br>EA<br>DF<br>I will need to add others<br><br>
</div>


<div>
<br><br>I want a sub form that you can tell me, you can select from these columns the ones you need to create the lookup<br><br>from that look up<br><br>then suggest the BYSET<br><br>that is, it is a column selector through a subform<br><br>It would be something like this<br><br>1-button<br>open its form to select the columns<br>2-I select the columns I want to do the look up<br>3- I specify which would be the reference column (with the filter that I want to use that will be a number)<br>this step 3 we currently do when we close the BYSET<br>because it is the one that allows me to call the data<br>4- the Byset is created<br><br>
</div>


<div>
I've done1 and 2 already..(Click the COLUMNS) button.<br />
3. If you select AU won't the reference columns always be the same?
</div>


<div>
<blockquote>3. If you select AU won't the reference columns always be the same?</blockquote>that's what i'm talking about<br><br>if we have a list of columns<br><br>and I can select the ones I want to use from the list<br><br>example there are 10 columns in the list<br><br>then I select 4<br><br>one of these 4 has to be defined as the column that has what will filter the other 3 columns<br><br>that is to say<br><br>the column that you select as the guide column will be the query or index to accommodate the information of the others<br><br>And this has to be defined before continuing with the creation of the BYSET<br><br><br>then<br><br>you can define that on the flight<br><br>I mean<br><br>I can have a program to tell the program this is going to do my index column or my guide column for the lookup<br><br>the idea is that it is interchangeable according to my need at the moment<br><br><br><br>have the flexibility to choose which will be the column that makes the query<br><br>if we achieve that we have the job done
</div>


<div>
Example RNUM button in BP columns opens a subform where I choose from the list of numbers drawn in a list that comes from a BP column<br><br>but that is fixed if I wanted to add another columns to compare information<br><br>it does not let me<br><br>it also doesn't let me select another column as the query or parameter to filter the data
</div>


<div>
I can't do what you want so you should probably close this question.
</div>


<div>
ok the question is closed already
</div>


<div>
I'll start on your other question.
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>4N fille to add BX from&nbsp;</p><p><a class="fr-file" href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572129/29223939.xlsb" rel="ugc">29223939.xlsb</a></p><p><span id="isPasted" style=" text-align: left;">When I click the Select TK Vertically button the userform in this picture is shown. I'd like to do the same for column "BX".</span>&nbsp;</p><p><br></p><p><br></p>
</div>
</div>



4N fille to add BX from 
29223939.xlsb
When I click the Select TK Vertically button the userform in this picture is shown. I'd like to do the same for column "BX".
 

userform for column bx 4npairs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.