sending data from one cell to another

[Maria]

I would like to have data from one cell get sent to another cell in the same
worksheet. But I don't want to put a formula in the second cell to grab that
data from the first cell. Is this possible?

For example, if I type in my first name in A1, I would like it to
automatically appear in cells A2, A3, and A4. However, I would like to have
the flexibility to type in my last name into A3 and have that then
automatically appear in A4 as well.

Thanks for your time,
Maria

 

[CyberTaz]

Sorry, Maria, but cells don't "send" anything anywhere, they *store* content.
If the content is also needed elsewhare it has to be retrieved from where
it's stored.

If you can describe why you believe you want to have the same content in
more than one place perhaps there are alternative methods of accomplishing
your goal... Just be sure to specify what version of the program you're using
as well as any other details.

Regards |:>)
Bob Jones
MVP Office:Mac

 

[Maria]

Hi Bob,

Thanks for looking at my question. Let's see if I can explain what I am
trying to do...I coach college hockey and we want to set up a chart of our
players. Basicially it would be our roster laid out by position, year, and
scholarship amount they get. So when we fill in the chart with the players
info, it would be linked to next year's roster and also the following 2 years
after that so we can plan ahead with our recruiting up through 2013.

So if we typed in a sophomore goalie into the 2009-2010 roster chart, her
info would automatically go onto next year's chart and automatically label
her a junior, then onto the next season as well and it would label her a
senior automatically as well. That's the easy part.

I can do all the formula stuff to make this work in a linear way but of
course you can't put in a fantasy future player into a box that has a formula
in it already. We are concerned with being able to manipulate the data for 2
and 3 years ahead by plugging in potential recruits and seeing how they fit
in our lineup.

I hope that makes sense and sorry if that is way too much info. I am using
excel 2003. 2 other guys said it would take VBA code to do it but I am not
saavy with that stuff at all. I been going through the tutorials and I
thought maybe if I was able to create "reset" button that we can get the
formulas back in if we need it but I couldn't figure it out.

Anyway, any help would be awesome and much appreciated. Thanks again-

-Maria

 

[Bob Greenblatt]

Hi Bob,

Thanks for looking at my question. Let's see if I can explain what I am
trying to do...I coach college hockey and we want to set up a chart of our
players. Basicially it would be our roster laid out by position, year, and
scholarship amount they get. So when we fill in the chart with the players
info, it would be linked to next year's roster and also the following 2 years
after that so we can plan ahead with our recruiting up through 2013.

So if we typed in a sophomore goalie into the 2009-2010 roster chart, her
info would automatically go onto next year's chart and automatically label
her a junior, then onto the next season as well and it would label her a
senior automatically as well. That's the easy part.

I can do all the formula stuff to make this work in a linear way but of
course you can't put in a fantasy future player into a box that has a formula
in it already. We are concerned with being able to manipulate the data for 2
and 3 years ahead by plugging in potential recruits and seeing how they fit
in our lineup.

I hope that makes sense and sorry if that is way too much info. I am using
excel 2003. 2 other guys said it would take VBA code to do it but I am not
saavy with that stuff at all. I been going through the tutorials and I
thought maybe if I was able to create "reset" button that we can get the
formulas back in if we need it but I couldn't figure it out.

Anyway, any help would be awesome and much appreciated. Thanks again-

-Maria

Maria,

PMFJI. But, first, this is a forum for Macintosh Excel. You said you are
using Excel 2003, which is a Windows version. However, what you are asking
applies to all versions and platforms.

It sounds like you can do what you want with formulas, but are concerned
about getting the formulas back if you destroy the formula by entering
directly in the cell. You may be able to accomplish what you want by
building a "skeleton" worksheet that retains all the formulas, and can be
used as a source of formulas to be pasted back into the working sheet.
Short of a rather extensive (and probably expensive) VBA solution you'll
have to do this manually.

Remember a formula can only change the value of the cell it is in. It can
not "push" data to somewhere else.

 

[Maria]

PMFJI. But, first, this is a forum for Macintosh Excel. You said you are
using Excel 2003, which is a Windows version. However, what you are asking
applies to all versions and platforms.

It sounds like you can do what you want with formulas, but are concerned
about getting the formulas back if you destroy the formula by entering
directly in the cell. You may be able to accomplish what you want by
building a "skeleton" worksheet that retains all the formulas, and can be
used as a source of formulas to be pasted back into the working sheet.
Short of a rather extensive (and probably expensive) VBA solution you'll
have to do this manually.

Remember a formula can only change the value of the cell it is in. It can
not "push" data to somewhere else.

Thanks so much, I was afraid that was going to be the case. Also, I did not
know this was for Mac, thanks for that too. All the best-

 

[Carl Witthoft]

Fundamentally, the tasks you describe are much better handled with a
database tool. You could use the one in OpenOffice.org, or
FileMakerPro, or any of the open-sourse SQL-types. (Granted there will
be a learning curve involved)
Carl

PMFJI. But, first, this is a forum for Macintosh Excel. You said you are
using Excel 2003, which is a Windows version. However, what you are asking
applies to all versions and platforms.

It sounds like you can do what you want with formulas, but are concerned
about getting the formulas back if you destroy the formula by entering
directly in the cell. You may be able to accomplish what you want by
building a "skeleton" worksheet that retains all the formulas, and can be
used as a source of formulas to be pasted back into the working sheet.
Short of a rather extensive (and probably expensive) VBA solution you'll
have to do this manually.

Remember a formula can only change the value of the cell it is in. It can
not "push" data to somewhere else.

Thanks so much, I was afraid that was going to be the case. Also, I did not
know this was for Mac, thanks for that too. All the best-[/QUOTE]