Formulas in the same column

[Bennos]

Hi all,

Is there a way to change the the formula in only one cell and for the new
formula to apply to all ther others in the same column.

eg. change cell "C1', same change to occur to "C2 to C380" automatically?
With the exception of a few cells "C23, C70, C220, C260" these are
descriptions.

Thanks in advance
Ben

 

[Ken Russell]

Hi Ben,

In C2 type +C1 and copy this formula to the cells C2..C380. In the cells
that are descriptions, just type your text, then change the following cell
to link to the cell before your description. eg. C23 would be text, then
change C24 to +C22. Do the same for the other cells that follow your
descriptions.

Ken Russell
Remove hat to reply by e-mail
(e-mail address removed)

| Hi all,
|
| Is there a way to change the the formula in only one cell and for the new
| formula to apply to all ther others in the same column.
|
| eg. change cell "C1', same change to occur to "C2 to C380" automatically?
| With the exception of a few cells "C23, C70, C220, C260" these are
| descriptions.
|
| Thanks in advance
| Ben
|
|

 

[Frank Kabel]

Hi Ben
no chance IMHO

 

[Bennos]

Frank,

What does that mean "no chance IMHO"??

Hi Ben
no chance IMHO

 

[Bennos]

Thanks Ken!

But instead of copying the value of C1 only, I was meaning that each cell to
follow is to contain its own formula that will apply to that particular row.
Each of these formulas has to change automatically with changes of the first
cell in that column (Change C1's formula and the formula changes to apply to
the other cells C2 to C300, excluding descriptions)

Can I email you an example file?

Regards
Ben

 

[Frank Kabel]

Hi
IMHO: In my humble opinion
So I don't see a way to achieve this automatically. You may change your
formula and copy it down for all other rows

 

[Bennos]

Isn't there a way to do a 'find' or 'go to' on a formula and apply changes
to similar formulas in a sheet?

Dam, I thought more of Excel, why can't it cook and clean as well....haha!

 

[AlfD]

Yes, Bennos: you can use Find/Replace to amend a batch of formulae.

But it's not automatic, in that you have a manual job to do.

Your apparent original aim (which read like "amend one and the res
will amend themselves") could be achieved through VBA, but even mor
work?

Al

 

[Dave Peterson]

I'm not sure what the formula is, so I'm not sure this'll work.

You can fill a range of selected cells with values or formulas by selecting the
range first, typing the format with respect to the active cell and then hitting
control-enter.

You may want to try this (against a copy or close without saving):
Give that range of discontiguous cells a nice range name.
Select your range starting at the bottom and working toward the top.
(I tried to make C1 my activecell when I did it).
type the range name in the namebox (to the left of the formulabar)
(and hit enter). I used MyFormulas in my test.

Now just for testing, select a different cell. Then use the namebox to select
myFormulas (it should be visible from the dropdown).

Write your formula and hit control-enter.

If your formula isn't too bad, maybe it even worked for you.

 

[JE McGimpsey]

If you use the List Manager in MacXL2001, MacXLv.X or WinXL2003, you can
define a column as Calculated - then you can change the calculation and
it will propagate to the entire column.

 

[Norman Harker]

Hi Benos!

We don't use all that many acronyms. Here's selection of them:

<bg> Big grin <g> Grin <vbg> Very big grin <vbeg> Very big evil
grin

AFAIK As Far As I Know

BCNU Be Seeing You
BTW By the way

DARFC Ducks And Runs For Cover

DLG Devilish Little Grin
FAQ Frequently Asked Questions
FOTCL Falling Off The Chair Laughing
FWIW For What It's Worth

FUBAR Fouled up beyond all recognition
FYA For Your Amusement
FYI For Your Information

FLW Famous Last Words

HTH Hope This Helps

IIRC = "If I recall correctly"
IMHO In My Humble Opinion
IMNSHO In My Not So Humble Opinion
IMO In My Opinion
KISS Keep It Simple Stupid
LOL Laughing Out Loud (or Lots of love depending on context!)

NG News Group

OP Original Poster (i.e. Person who started the thread)

OT Off Topic (Often used to prefix subject line)
OTF On the floor. Short form of ROTFL.
OTOH On The Other Hand
PD Public Domain

PMFJI = Pardon me for jumping in
ROTFL Rolling On The Floor Laughing

RO(T)FL(MAO) = Rolling on(the) floor laughing (my ... off)
RTFM Read The Fine Manual. Used when a stupid question is asked

SNAFU Situation Normal, Another Foul Up
TIA Thank In Advance
TNX Thanks
TNX 1.0E6 Thanks a million (humorous)



Further sources:



http://www.ucc.ie/cgi-bin/uncgi/acronym

http://www.utdallas.edu/ir/tcs/techsupp/acronyms.html#C

http://www.acronymfinder.com


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.