Linking two sheets

Hi everybody,

I got a data series in the sheet1: can i create a sheet2 in the way that if i update the sheet1, the sheet2 will be automaticaly updated?

Thanks in advance

PS sorry for the title, i hope that now is correct

The_jackal

Please take a couple of minutes and read the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1)

You can use simple formulas in Sheet2.

For example, if you want Sheet2!A1 to equal Sheet1!A1 then

in Sheet2!A1 you enter formula =Sheet1!A1.... anytime you update Sheet1!A1, then Sheet2!A1 will update automatically

Originally Posted by The_jackal

Ok done, but now i`ve got this problem: in the "sheet 2" for each empty cell coming from "sheet 1" appear the value 0....how could I avoid this?

If there is a chance that some of the cells in your original sheet have 0's and you want to see them, then your formulas would be revised to something like:

=if(Sheet1!A1="","",Sheet1!A1)