<div>
<blockquote>
it don't work !
</blockquote>
That doesn't tell me what is wrong, but when make a change to the 3P sheet I get this. If it isn't correct please tell me what is wrong.<a href="https://filedb.experts-exchange.com/incoming/2021/04_w18/1558806/2021-04-27_06-43-00--1-.png" target="_blank" title="2021-04-27_06-43-00--1-.png (53 KB)"><img alt="2021-04-27_06-43-00--1-.png" class="file-block lazyload" style="max-width: 276px;" data-src="https://filedb.experts-exchange.com/incoming/2021/04_w18/1558806/2021-04-27_06-43-00--1-.png" /></a>
</div>


2021-04-27_06-43-00--1-.png

<div>
I change the data in E6 to E15<br><br>then add data in C24 to C35<br><br>i expect have the location &nbsp;fo 3N &nbsp;E24 to I35<br><br>but dont change&nbsp;
</div>


<div>
Are the results in my picture correct?
</div>


<div>
<blockquote>Are the results in my picture correct?&nbsp;</blockquote><br>Yes !
</div>


<div>
when i change the values it don't work<br><br>i try to refresh with F2 &nbsp;shortcut <br><br>but it dont work
</div>


<div>
<blockquote>
when i change the values it don't work
</blockquote>
What values?
</div>


<div>
I will have always change&nbsp;<br><br>E6 to E15<br><br>and &nbsp; C24 to C35<br><br>&nbsp;
</div>


<div>
This workbook and all of the other &quot;map&quot; workbooks that I've written for you all behave the same way. When you make a change to the bottom part (in this case C24 to C35), you will see results. If you change the top part (in this case E6 to E15) nothing will happen. So in other words if you change the top part and then you change the bottom part you will see results, but if you just change the top part or if you change the top part after you change the bottom part you will not see any change in the results.<br />
<br />
Este libro de trabajo y todos los demás libros de trabajo de &quot;mapas&quot; que he escrito para usted se comportan de la misma manera. Cuando realice un cambio en la parte inferior (en este caso C24 a C35), verá resultados. Si cambia la parte superior (en este caso E6 a E15) no pasará nada. Entonces, en otras palabras, si cambia la parte superior y luego cambia la parte inferior, verá resultados, pero si simplemente cambia la parte superior o si cambia la parte superior después de cambiar la parte inferior, no verá ningún cambio en los resultados.
</div>


<div>
ok what will happens when i forget that so i do wrong<br><br>is not an way to reset it ?<br><br>becuse i try to get it to work but i fail
</div>


<div>
After you change the top part if you change one or more cells in the bottom part you will see results. But I will change this workbook so you don't need to do that.<br />
<br />
Después de cambiar la parte superior, si cambia una o más celdas en la parte inferior, verá resultados. Pero cambiaré este libro de trabajo para que no tenga que hacer eso.
</div>


29214453.xlsm

ACCOUNTING ASSISTANT

ADRIANA P

<div>
<div class="content wysiwyg-content fr-view">
<a href="https://filedb.experts-exchange.com/incoming/2021/04_w18/1558800/29212673.xlsm" rel="ugc">29212673.xlsm</a><br><br>when added data to 3P sheet <br><br>it don't work !
</div>
</div>


29212673.xlsm


29212673.xlsm
when added data to 3P sheet
it don't work !

Adjust  3N File  with  NON-printing characters  ONEDIGITTOP

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.