Indesign and Exceldhayn (179 pencils) | Thu, 2006-01-12 15:57
I've got a dilemma that plagues me repeatedly every year. In this catalog that I do there are thousands of parts that I make into neat little tables so everybody can read. But the price changes on them.
Now that Indesign has support for tables I entered them all in last year and got them all to look how I want but now the prices are changing again. We have an Excel spreadsheet with every part number and it's price. The problem is that the spreadsheet doesn't have anything to do with the order of the tables. It is just every single part number in alphabetical order and the price next to it so it's a lot of work to match these things up.
Is there any way that I don't have to go through and type them all into Indesign yet another year? Please.
Another temporary solution is that the prices are going up this year by a certain percent across every part. Is there any way I can just somehow multiply the values in that column of the table.
Any solution is probably more work than just typing them all out but if it will save time next year and the year after that I don't care.
Here's an example of one table:
Commenting on this Forum topic is closed.