Hi Ruchie,

Yes, there way to link the two worksheets.

Let us assume that RAW DATA is in Sheet1(Eg. A1=Apple; A2=Boy; A3=Cat and so
on......)
COPIED DATA is in Sheet2

You want.... whatever changes made in Sheet1 should be reflected in Sheet2

Now coming to the solution:(Assume that you are in Sheet1)

1. Press Ctrl+Shift+Page Down buttons(both Sheet1 and Sheet2 are highlighted)
2. Press Ctrl+Click on Sheet2 Tab(both Sheet1 and Sheet2 are highlighted)


You change the RAW DATA in Cell A1 from "Apple" to "Ant"(Sheet1)
The same will be reflected in COPIED DATA (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?