ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to push data to another cell (https://www.excelbanter.com/excel-worksheet-functions/144726-how-push-data-another-cell.html)

Wawa

how to push data to another cell
 
for example, i want to put a value in cell A3. then, when i insert a new
value in A3, i want the B3 to have the old value of A3. same as before, when
i put another new value in A3, B3 will have the older value and C3 now will
have the oldest value. what sholud i do please...

JE McGimpsey

how to push data to another cell
 
One way:

Insert a cell before inputting your value in A3. You could record a
macro of that action and assign to it a keyboard shortcut or toolbar
button.


In article ,
Wawa wrote:

for example, i want to put a value in cell A3. then, when i insert a new
value in A3, i want the B3 to have the old value of A3. same as before, when
i put another new value in A3, B3 will have the older value and C3 now will
have the oldest value. what sholud i do please...



All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com