MrExcel Publishing
Your One Stop for Excel Tips & Solutions

urgent


Posted by angela on June 29, 2001 12:00 PM

How do I create an array formula or a spreadsheet that moves data from one cell to another?

Thanks.


Posted by Joe Was on June 29, 2001 3:49 PM

I need more information!

To reference the value of one cell in another location:

put the data cell reference in the new cell:

as, =cell address like data in cell A1
New cell formula ==> =A1 then whatever is in A1 will also be in your now cell.

Or, Right click the cell value you want to move and select Cut. Then select your new cell and Right click and select Paste.

Or, write a macro that takes whatever is entered in a cell (acting like an input box) and puts it into a new cell on your sheet? JSW