Copy and the editpaste 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" wrote in message
...
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.