Hi Ruchie,
Let me put you problem like this:
In Sheet1, there is a RAW DATA (Eg. in cell A1 "Apple"; A2 "Boy" etc......)
and you copied it into Sheet2.
If you change the data in Sheet2 (Eg. in Cell A1 from "Apple" to "Ant")
the same should happen even in Sheet1.

There are two methods(Assume that you are in Sheet1):
1. Press Ctrl+Shift+Pagedown buttons
2. Press Ctrl and click on Sheet2

Whatever changes you make in Sheet2 will be applicable to Sheet1 also.
In the above case, Apple will be changed to Ant in both Sheet1 and Sheet2.


SAWTHEYA.




"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?