Don't copy and paste the data. Go to the second worksheet and link to the
data on the 1st by putting =A1 in the first block you want copied then you
can drag that link to the other fields you need on the second sheet. Then
enterwhatever operations you need. Then if the information on the first page
changes, it will automatically change on the second sheet.

I hope this is what you are looking for!

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