Conditional Removal of Text

**forsberc** · 10-20-2008, 05:16 AM

Hello All!

I am currently working on a project in which I have two sources of data. I have made a drop down list to select which data is used. It all works, however, I am in the process of beautifying it all.

I am trying to overwrite a cell with information from another cell only when another cell is active. I have tried many ideas and am currently running out of ideas. I am currently using Excel 2008 for Mac, however, it should be very similar (except without macro support

...).

An example of what I am trying to accomplish is as follows:

If A1 is false, then I want use the information from C1. But when A1 is true, I want to use information from C2 and replace C1 with the information.

I know how to always do that, but I do not know how to place a condition on it that allows for future editing of C1.

I hope that all makes sense. I am looking forward to some help.

Thanks,
Cameron

Excel 12.1.3
OS 10.5.5

**Stuie** · 10-20-2008, 05:26 AM

Hi forsberc,

no formula/function is able to edit another cell other than the cell it resides in.

is the data from C1 or C2 going to be displayed in the same cell or is it in a diferent cell depending on A1

**xld** · 10-20-2008, 07:05 AM

Where you need to insert that value, can't you just use

IF(A1,C1,C2)

**forsberc** · 10-20-2008, 11:57 AM

Thanks for all the information. If a cell cannot change the contents of another, is there a way to conditionally "hide" it from view so that another cell right next to it can overlap it?

thanks for help,

cameron

**forsberc** · 10-20-2008, 02:50 PM

Originally Posted by Stuie

is the data from C1 or C2 going to be displayed in the same cell or is it in a diferent cell depending on A1

I want when A1 is true, I want C1 to display the data that is from C2. However, when A1 is false, I want to input the data into C1.

My goal is to have two options. Run automatically or manually. When run in manual mode, the user types in information into certain cells and then it is computed. However, when it is automatic mode, I want to have the data inputed and decoded somewhere else and then shown in these same cells inorder to create a streamed-lined, easy viewing experience.

I hope you all can see what i am trying to do now.

Thanks so much for the assistance,
Cameron

**forsberc** · 10-20-2008, 03:49 PM

Is there a way to type into a cell and not remove the formula there? It just occurred to me that if this works, then I know how to fix the problem.

-Cameron