Equivalent of Paste Special in Numbers

Hello

It seems that you are dreaming.

In AppleWorks the "copy special" _was not summarizing something_.

It allowed us to paste values only ( _which is available in Numbers as "Paste values"_ )
and allowed us to transpose a block of cells (which is NOT available in Numbers)

XL is a µSoft product.
Numbers is an Apple product which comply to "Apple Human Interface Guide".
This document states something like "if a feature is not useful to 80% of the users, don't code it".
It seems that you are one of the other 20% 😉

If you really want it, you may *go to "Provide Numbers Feedback" in the "Numbers" menu*, describe what you wish.
Then, cross your fingers, and wait at least for iWork'09 😉

Yvan KOENIG (from FRANCE mardi 12 février 2008 22:01:46)

so on the summary sheet you simply type in an equals sign and then point to the cell in the first sheet (you'll see it say "sheet 1:B22" for instance). Now you can change B22 as much as you want and that will be reflected in the summary sheet.

"Paste Special" is used when you want to take something that's been calculated and save just the value that's currently in it. (for instance, if you go to D2 and enter B2+C2 in the formula bar, you'll see the sum in D2 but in the formula bar you'll still see the FORMULA. If you COPY that cell, then paste it somewhere else, just plain paste, the formula will be pasted in and will change if you change the contents of B2 or C2, wherever you paste it, in the same sheet or a diffeerent sheet. IF, on the other hand, you Paste Value, then the *actual sum* of B2 and C2 at the time you did that calculation will stay the same when it's pasted in elsewhere. Play with it and you'll see how it works. It's a very useful trick to learn.

There is no such "summarize" feature in Numbers.

I assumes that it was supposed useful for less than 20% of the potential users.

If you think that it is useful, *go to "Provide Numbers Feedback" in the "Numbers" menu*, describe what you wish.
Then, cross your fingers, and wait at least for iWork'09 😉

Yvan KOENIG (from FRANCE mardi 12 février 2008 18:26:00)

John,

Copy and Paste won't do what you want, but why not just reference the working sheet's cell in the summary sheet?

In the Summary Sheet, select a cell and type "=", then click the source cell in the working sheet, then press "Return".

Now your Summary Data will update anytime the source cell content changes.

Jerry

John,

I'm only guessing what type of summarizing is involved, but if you are summarizing results from two tables in a third, couldn't you just use a formula like: =Table 1 :: A10+Table 2 :: A12 rather than pasting values? Or if you want to show those two values in the third table, enter them in separate cells with: =Table 1 :: A10 and =Table 2 :: A12.

pw

Paste special isn't what you need if you want the summary data to change according to entries in the other table/sheet. Use the formulas from other posters above and create an equation that will do it for you.

Jason

I think you can copy and then use Edit -> Paste Values