Excel

[Christine Kempf]

How do I copy information from a batch of cells in one
worksheet to another worksheet in the same workbook? I
do not need a copy and paste - I need the data within
these cells (which is different everytime) to
automatically transfer to the second worksheet every time
I enter in new data.

[Peo Sjoblom]

Copy and the edit>paste special and click the paste link button

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Christine Kempf" <cdkempf@comcast.net> wrote in message
news:031501c4fe9d$77d0a6e0$a301280a@phx.gbl...
> How do I copy information from a batch of cells in one
> worksheet to another worksheet in the same workbook? I
> do not need a copy and paste - I need the data within
> these cells (which is different everytime) to
> automatically transfer to the second worksheet every time
> I enter in new data.