I am working on creating packaging for the compnay i work for (boxes, cases ect.) I am using the place> spreadsheet option to populate 20 diff areas on the box, things like size, sku# and mfg#. Ideally what i need indesign to do is when i create a new box (new page or duplicate page) to have indesign use the next row in excel. Duplicating the page just makes the populated areas use the same row (obviously). Having to place the spreadsheet 20 times every time i want to create a new box with new cell values is not time efficient. Id be better off not using the place> spreadsheet option at all. Ive considered making a new cs6 page/ file for each box with its own excel spreadsheet and delete a row which pushes everything up everytime I create a new box. However, if i do that i lose the efficiency of the master page (basically if there is a change on all the boxes i would have to make these changes to each file). I just finished doing spec sheets and i must have changed those master pages about ten times. There are ~230 boxes and ~230 cases that need to be created. Is this even possible, thank you in advance!
How to link these spread sheet to indesign and when you make any change update in indesign, you can do that: Edit>Preferences>File Handling>Links>check on : Create links when placing text and spreadsheet files.
Yes i have that option checked for when i make changes to my excel sheet it auto updates in Indesign, awesome feature. Its already saved me days possibly weeks worth of work. However, what i need it to do is when i create a new page/ box to use the next row in excel, sort of similar to the "Fill" option in excel. Filling down takes the same formula but pulls from different rows.