give a link to sheet2
sheet1 cell copy and go sheet2 and paste special as a link

"cariina" wrote:

How to move an answer i worksheet1 to worksheet2,
so if i make changes in worksheet1 it will also change i worksheet2?
/C