Hi, Using Cell References, you should be able to do what you’re asking. So, for example, in your case, I’d do the following:
• move to cell B1 inn Table B. • Enter the formula “=Table C::B1”. Assuming your wanting to mirror the same cell reference in the other table. • Normally, we’d just do an Auto-Fill Down here, but I can’t seem to make that work in this situation, so, simply copy the contents of Table B, cell B1 then paste it into B2. B3, B4 etc. Not the prettiest, but it will do the job. Now, if you change something in those referenced cells in Table c, they will automatically be changed accordingly in Table B. You’ll be able to also apply formulas to the data in Table B if necessary. There’s supposed to be some keyboard shortcuts to handle this as well, but I haven’t got them to work for me yet either. I’ll play some more and update if I figure out anything profound. Later... Tim Kilburn Fort McMurray, AB Canada On Mar 16, 2015, at 10:19, Jürgen Fleger <apple-engl...@fleger.net> wrote: Hi, Is there a way to mirror a column in another table at once? Or do I really have to define formulars for each cell? I want column B1 to B37 in Table A to apear exactly as it is in Table C. Would be a lot of work. Additionally I want the column in Table C to change if I change values in column B in Table A. That's why I don't want to simply copy and paste it to Table C. @Phil: I agree, it's good to read the manual of Numbers but in terms of searching in it I'm not that successful. ;-) That's why I'm so glad to know this list. :-) Thanks for help and all the best Jürgen -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
