copy results of formula to another cell

Is there a way to return results of a formula to a cell other than the one where the formula is located?
I am working on a scheduling spreadsheet. I need to automatically insert an "x" in each cell imediately following certain other letters. I can put in a formula for that, but those formulas get wiped out if i change my mind about where to insert the letters.
I can put the formula below my chart, but I need the results returned to differnrent cell. Is there a way to return results of a formula to a cell other than the one where the formula is located?

Hi,

Is there a way to return results of a formula to a cell other than the one
where the formula is located?

No, you need VBA code for that.

Post back (no attachments please) with more details on your setup and what you
want to achieve.

Regards
Anders Silven

Use two formulas ??

If you're going to wipe out a formula and want another formula
to be generated you could use an Event Macro.
http://www.mvps.org/dmcritchie/excel/event
to create a formula.

I don't really understand what you have but it can probably
be accomplished without macros by simply inserting another
column. Perhaps you could use something like on of the following
=OR(a2="x',b2="X", c2=x)
=IF(a2"",b2"",c2"", "buy more widgits", "")

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ScheduleQueen" wrote in message
...
Is there a way to return results of a formula to a cell other than the one where the formula is located?
I am working on a scheduling spreadsheet. I need to automatically insert an "x" in each cell imediately following certain other
letters. I can put in a formula for that, but those formulas get wiped out if i change my mind about where to insert the letters.
I can put the formula below my chart, but I need the results returned to differnrent cell. Is there a way to return results of a
formula to a cell other than the one where the formula is located?

ScheduleQueen,

See your other post as well, and please don't multipost.

Regards
Anders Silven

"ScheduleQueen" skrev i meddelandet
...
Is there a way to return results of a formula to a cell other than the one
where the formula is located?
I am working on a scheduling spreadsheet. I need to automatically insert an
"x" in each cell imediately following certain other letters. I can put in a
formula for that, but those formulas get wiped out if i change my mind about
where to insert the letters.
I can put the formula below my chart, but I need the results returned to
differnrent cell. Is there a way to return results of a formula to a cell other
than the one where the formula is located?

Hi, thank you for trying to help.... I'll try to make my explanation simple:
for example, if cell A1 contain the letter c, i need to set cell A2 to be x

That would be simple in and of itself, but sometimes i need to move the "c"'s; each time I enter "c" I wipe out the formula.

I want to put the formula below, say in AA1, to tell it if a1=c, then make a2=x

(there are actually multiple variables that need to result in an "x" to their right)

I hope this is clear... thanks for trying to help... sorry about double posting - I've not used this before and am fumbling with it a bit - Judi

"Anders Silven" wrote:

Hi,

Is there a way to return results of a formula to a cell other than the one
where the formula is located?

No, you need VBA code for that.

Post back (no attachments please) with more details on your setup and what you
want to achieve.

Regards
Anders Silven

If you wipe out a formula there is no way of telling what that
formula was afterwards. You would have to know where the formula
has to go and what should be in the program. All the program
can actually pick up is the address of a cell that was changed and
it's new value, and formatting options but I don't thank that matters.

I think you're back to my suggestion of using another column.

I'm also not sure that you are making things simpler as AA1 is
off the right instead of down from A1.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ScheduleQueen" wrote in message
...
Hi, thank you for trying to help.... I'll try to make my explanation simple:
for example, if cell A1 contain the letter c, i need to set cell A2 to be x

That would be simple in and of itself, but sometimes i need to move the "c"'s; each time I enter "c" I wipe out the formula.

I want to put the formula below, say in AA1, to tell it if a1=c, then make a2=x

(there are actually multiple variables that need to result in an "x" to their right)

I hope this is clear... thanks for trying to help... sorry about double posting - I've not used this before and am fumbling with
it a bit - Judi

"Anders Silven" wrote:

Hi,

Is there a way to return results of a formula to a cell other than the one
where the formula is located?

No, you need VBA code for that.

Post back (no attachments please) with more details on your setup and what you
want to achieve.

Regards
Anders Silven