<div>
The numbers that you show on the ONE3N sheet from rows 5 to 6775 seem to be the numbers from column 'E' rows 7 to 6777 of the 3NPair sheet. Where do the rest of the numbers on the ONE3N come from?
</div>


<div>
i did one column from E7 + F7 + G7<br><br><br>need do the same but&nbsp; with date selector
</div>


<div>
That does not seem to be the case. The last value in 52W2021 in column 'C' of the 3NPAIR sheet is 26 and you show that in C6775 of the &nbsp;ONE3N sheet, but in C6777 you show 85. Where does the 85 come from?
</div>


<div>
I see sorry <br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561249/ex12.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561249/ex12.PNG" class="fr-fic fr-dib"></a>
</div>


ex12.PNG

29216013.xlsm

ACCOUNTING ASSISTANT

ADRIANA P

<div>
Lead The Way !!<br><br>Best Expert !
</div>


<div>
have an situation when i add a new year it do not tshow up<br><br>need an solution for add news years to comes as always i add new data always<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561259/29216013.xlsm" rel="ugc">29216013.xlsm</a>
</div>


<div>
I don't understand what problem you are having. The 'Select Date Range' button works for me with the new data.
</div>


<div>
You Rigth Best Expert !!<br><br>i did not closed and open the file<br>after i did it shows the 2022 year !!<br><br>Great Job !<br><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
3n_w_pairs<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561246/29215977.xlsm" rel="ugc">29215977.xlsm</a><br><br>By date create one column of the pairs<br>in sheet ONE3N<br><br>1-select date by month and years &nbsp;(not just years)<br><br>2- from the selected DATE but the 3 columns of pairs in one column<br><br>&nbsp;<br><br><br><br>
</div>
</div>


29215977.xlsm


3n_w_pairs
29215977.xlsm
By date create one column of the pairs
in sheet ONE3N
1-select date by month and years  (not just years)
2- from the selected DATE but the 3 columns of pairs in one column
 

The numbers that you show on the ONE3N sheet from rows 5 to 6775 seem to be the numbers from column &amp;#39;E&amp;#39; rows 7 to 6777 of the 3NPair sheet. Where do the rest of the numbers on the ONE3N come from?


i did one column from E7 + F7 + G7
need do the same but  with date selector

That does not seem to be the case. The last value in 52W2021 in column &amp;#39;C&amp;#39; of the 3NPAIR sheet is 26 and you show that in C6775 of the  ONE3N sheet, but in C6777 you show 85. Where does the 85 come from?


have an situation when i add a new year it do not tshow up
need an solution for add news years to comes as always i add new data always
29216013.xlsm

I don&amp;#39;t understand what problem you are having. The &amp;#39;Select Date Range&amp;#39; button works for me with the new data.


You Rigth Best Expert !!
i did not closed and open the file
after i did it shows the 2022 year !!
Great Job !

By Date 3N PAir Column

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 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

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.