software

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like quot;if data in this cell, then move toquot;

So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2=quot;Xquot;,A2,quot; quot;)

quot;kimtrussquot; wrote:

gt; Have a large spreadsheet, need to move certain cells in one column to another
gt; column. Column where data is has other information I do not wish to move.
gt; Need a formula something like quot;if data in this cell, then move toquot;

Have entered this formula, but does not work. I want the data in column a to
move to column c regardless of what the cell content of column a is. Any
ideas?

quot;PARquot; wrote:

gt; So, you have data in column A and you want to move data to Column C if the
gt; value =x?
gt;
gt; In Cell C 2 put =If (A2=quot;Xquot;,A2,quot; quot;)
gt;
gt; quot;kimtrussquot; wrote:
gt;
gt; gt; Have a large spreadsheet, need to move certain cells in one column to another
gt; gt; column. Column where data is has other information I do not wish to move.
gt; gt; Need a formula something like quot;if data in this cell, then move toquot;

Can you be more specific about your table set up and what you are trying to
accomplish? If you want to move data, you can cut and then insert cut cells.
Or, have enter =A2 in cell C2.
quot;kimtrussquot; wrote:

gt; Have entered this formula, but does not work. I want the data in column a to
gt; move to column c regardless of what the cell content of column a is. Any
gt; ideas?
gt;
gt; quot;PARquot; wrote:
gt;
gt; gt; So, you have data in column A and you want to move data to Column C if the
gt; gt; value =x?
gt; gt;
gt; gt; In Cell C 2 put =If (A2=quot;Xquot;,A2,quot; quot;)
gt; gt;
gt; gt; quot;kimtrussquot; wrote:
gt; gt;
gt; gt; gt; Have a large spreadsheet, need to move certain cells in one column to another
gt; gt; gt; column. Column where data is has other information I do not wish to move.
gt; gt; gt; Need a formula something like quot;if data in this cell, then move toquot;

Formulas cannot quot;movequot; data.

Formulas can only return results into the cell(s) in which they are written.

To move data you would require VBA code, either event code or a macro routine.Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 20:11:01 -0700, kimtruss
gt; wrote:

gt;Have entered this formula, but does not work. I want the data in column a to
gt;move to column c regardless of what the cell content of column a is. Any
gt;ideas?
gt;
gt;quot;PARquot; wrote:
gt;
gt;gt; So, you have data in column A and you want to move data to Column C if the
gt;gt; value =x?
gt;gt;
gt;gt; In Cell C 2 put =If (A2=quot;Xquot;,A2,quot; quot;)
gt;gt;
gt;gt; quot;kimtrussquot; wrote:
gt;gt;
gt;gt; gt; Have a large spreadsheet, need to move certain cells in one column to another
gt;gt; gt; column. Column where data is has other information I do not wish to move.
gt;gt; gt; Need a formula something like quot;if data in this cell, then move toquot;