if you changed only the formatting Select the data you are interested in on
the first book copy, go to second book and paste special-paste link.

"ruchie" wrote:

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?