View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 99
Default Update of two cells from a cell.

hi luis vejarano,

voir la solution de MichD sur microsoft.public.fr.excel
see MichD solution on microsoft.public.fr.excel
ver solución MichD en microsoft.public.fr.excel
vedi soluzione MichD su microsoft.public.fr.excel
I'm sorry if I did not recognize your language, please tell me.

isabelle

Le 2015-10-06 12:05, luis vejarano a écrit :
Hello group such good day.
Do I make myself clear:
A1 I have a cell that can enter values manually, for example numbers: 1, 2, 3, etc.
I have the cell B1 has a value of cell A1.
ie if A1 = 2, B1 B1 = 2 should appear.
Now
if I modify: A1 = 3, cell B1 MUST REMAIN 2 (B1 = 2).
and in cell B2 it says the new value A1 (B2 = 3) should appear.

if not understood, there is a way to do with formulas ?, or if any macros,
if I could give an idea of a macro, because I'm not very familiar with macros theme.

thanks for the reply you can give me a greeting.