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
-------------------------------------------
"Dave R." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >
> > I want to reference a cell (A1) that has a link. What's a formula i can
> > use to reference the value with the link so that everytime i update A1
> > it will update A2 with the exact same info and format???
> >
> > thanks!!
> >
> >
> > ------------------------------------------------
> > ~~ Message posted from http://www.ExcelTip.com/
> > ~~View and post usenet messages directly from http://www.ExcelForum.com/
> >
>
>
Similar Threads
