Rather than pasting b1 into each individual cell B2 through be 37, first copy be one and then select B2 through B37 and then do the paste. Numbers will auto fill B2 b37 with the contents of B1 and automatically adjust the cell references for you. Check the cell references to make sure their correct. You may have to include a $ for the difference between absolute and relative addressing.
Sent from my IPhone > On Mar 16, 2015, at 2:02 PM, Tim Kilburn <kilbu...@me.com> wrote: > > 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. -- 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.
