Copy link to clipboard
Copied
Looking to upgrade work documents. There's a lot of paperwork to fill out, sometimes repeating the same information multiple times. One aspect is that we have to lookup data on an embedded excel sheet that works kind of like a book. Column A = book title, B=Page, C=paragraph D=sentence and each row is a sentence. Is there a way to "attach" an excel sheet to adobe, and somehow write a program or format it so it will auto populate the D column if given the Columns A-C and they are all in the same row?
I have heard Indesign might be a suitable program to make this, but still don't know how to implement it. I really don't want to make a matrix in java with all the data because there are THOUSANDS of columns. Any help is appreciated.
Copy link to clipboard
Copied
Hi
You can place an Excel table into InDesign as a link and then update the link with the information changes in Excel. You need to format the table in InDesign using Styles for the paragraphs (text), cells, and the table.
You've asked in the Acrobat forum, though. Shall I move this thread to the InDesign forum?
~ Jane
Copy link to clipboard
Copied
If you think that program is much better to accomplish the task, yes please!