Monster

Q: Auto copy the content of a text box to other tables

Hello, I have 4 tables in one file and the first table is my main template where all data is entered. Then som data from the main template is auto inserted into cells of the other tables. All good so far.

However I also have a text box in my main template and I would like to copy the content from this box into similar boxes on the other templates. Since this is not a cell I cannot find a way to auto copy the content to the other template text boxes.

The text box is used for entering a customer name and address. It would be a lot easier with a cell but I just can't make it look nice and stay in the "right" place if I where to use a cell.

iMac, Mac OS X (10.5.5)

Posted on Oct 2, 2016 12:25 PM

Close

Q: Auto copy the content of a text box to other tables

  • All replies
  • Helpful answers

  • by Barry,

    Barry Barry Oct 2, 2016 2:31 PM in response to Monster
    Level 7 (32,502 points)
    iWork
    Oct 2, 2016 2:31 PM in response to Monster

    Hi Monster,

     

    Try using a single cell table in place of the text box. The one on your main sheet will need to be unlocked, but the others can be locked in size, shape and position as they'll be filled by formula, not from the keyboard.

     

    Regards,

    Barry

  • by Monster,

    Monster Monster Oct 2, 2016 3:01 PM in response to Barry
    Level 1 (28 points)
    iWork
    Oct 2, 2016 3:01 PM in response to Barry

    I´ll try this but I´m not sure as to how I can freely position the copied content on the following tables. The middle part of each table is used for entering e.g. article no, description and so on. So If I need enough vid in a cell at say the top right corner, then I´ll likely mess up my preferred colonne vid further down in the table.

    However I´ll try and see if I can fit in a fixed cell size/position on the following tables.