Hi Ruchie,

Yes, there is way

1. Pess Ctrl+Another Worksheet Tab(Sheet2)

2. Press Ctrl+Shift+Page Down Buttons.

Whatever changes you make in RawData Worksheet(Sheet1), it will be reflected
in the Another Worksheet(Sheet2).


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