docstogo quest

[William_nd]

I cannot figure out how to copy the sum of a cell in sheetA to sheetB on the same file on my handheld.

On the pc it is a simple 'cut and paste special yadiyadiblabla' function, and since I want to keep the pc just as a backup machine, I rather want to know how to do it on my TungstenE.

please help, I Really don't want to keep my TungstenE at home as backup machine and hit the road and plane with my pc and a 500watt generator.

[Telyx]

Use a formula in Sheet2 to refer to the cell in Sheet1 with the sum you want. For example, I have a loan calculator in Sheet1 and want to have the P&I payment automatically copy to a certain cell in Sheet2. Here's the setup:

The P&I payment in Sheet1 is in cell D7.
The cell I want to paste that payment into in Sheet2 is A1.
So, in cell A1 in Sheet2, I write the formula =Sheet1!$D$7

(I don't recall the function of the ! after the sheet name, but it has to be there. The $ before the cell letter and number mean the formula in Sheet2 will always pull the value from that exact cell in Sheet1.)

[William_nd]

Many Thanx Telyx,

The formula you sent works perfectly, I am very grateful.

I was also wondering if there is a way to 'lock' a bookmark to a certain cell.
When I insert cells above my current bookmark, the results of the bookmarked cell go down, while the bookmark itself stays behind on the same place (¿Or is it rule to edit all bookmarks every time when inserting cells?, I hope not).

thanx again

[Telyx]

Usually in Excel, if you add cells or rows, any formulas in the existing cells are automatically moved too. I think you've found a Documents to Go problem.