ruchie,

If you want linked data, you copy, then paste special - paste link to the linked place.
That puts a link to the original cell(s). You can't change the linked cells -- only the
originals. It's not a two-way street. If you mess with the cell containing the link, you
destroy it.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"ruchie" wrote in message
ups.com...
i have a raw data worksheet, and i created another worksheet by
copying the raw data into it. after that, i performed some operations
on the new sheet, but then i realized that if i change the raw data,
it wont be reflected in the new sheet i created out of it. is there a
way to link the two worksheets now?