Hello, i need to know exactly how syncronize a cell in one sheet in a spreadsheet when a spesific cell in an other sheet changes.
Have a look at the help files with search term "multiple sheets".
Well, while I'm on it, here's how:
You can refer to a cell in another sheet with
Sheetname.Cell, where Sheetname is the name of the sheet and Cell is the cell. Default names are Sheet1, Sheet2, and so on.
Assuming you want to have a sum of cells A2 to A7 on Sheet1 in Sheet2.
That's done with SUM(Sheet1.A2:A7). You can also do that with mouse, if you want to.
I am not sure how you do that from another file altogether. -- Maailmassa eniten tuhoa aikaan saanut kemikaali on testosteroni. The most destructive chemical in the world has been testosterone. - Mixu Lauronen
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
