copying contents of a cell into another

[alex10for2]

I want to reference a cell (A1) that has a link. What's a formula i ca
use to reference the value with the link so that everytime i update A
it will update A2 with the exact same info and format???

thanks!

 

[ryanb.]

=A1

ryanb.

 

[Dave R.]

To get the same format, the easiest way is to copy and paste A1 into A2,
then delete A2 and put =A1 into A2. Copy/pasting transfers the format over.

 

[Earl Kiosterud]

Or for the formatting you can use the Format Painter. It copies formatting
from cell to cell. Click A1, then turn on the Format Painter (paint brush
button on the standard toolbar), then click A2. This can be done after the
formula (link) has been put in A2, or before.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

To get the same format, the easiest way is to copy and paste A1 into A2,
then delete A2 and put =A1 into A2. Copy/pasting transfers the format over.

 

[alex10for2]

both worked great! thanks guys, my app is coming along nicely!