Hi Tim and Phil, worked like a charm. Thanks for your support. That helped me a lot. :-) I’m totally stunned how easy it is to work with Numbers. How cool. All the best Jürgen
> Am 16.03.2015 um 19:45 schrieb Phil Halton <[email protected]>: > > 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 <[email protected]> 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 <[email protected]> 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 [email protected]. >> To post to this group, send email to [email protected]. >> 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 [email protected]. >> To post to this group, send email to [email protected]. >> 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
