So I have a excel file that comes in via PDF everyday that can have 50 lines of data or it can have 100 (one will be coming soon with almost 1000 lines.
My task is to take the data as it is shown on the excel file (which is really a PDF that was exported to excel). In addition to a few others reports but I think if I can figure out this then I can do the same for the other reports.
Once I have converted to excel then I need to present the data in word (both with the Table and with the summary as seen in the picture).
Is there any way I can automate or semi automate this? Unfortunately having the pdf/excel format changed is not an option. The only way I could think is some sort of mail merge but I don't know how to do a dynamic amount of lines vs creating 1000 documents lol.
I might be spending the next few days of my life just doing this all manually once that big one comes in but i will be forever grateful if someone has another idea.
Thanks in advance!!
Picture was to large to upload
. Apologies for the cell phone screenshot cant access this site on my work computer.
My task is to take the data as it is shown on the excel file (which is really a PDF that was exported to excel). In addition to a few others reports but I think if I can figure out this then I can do the same for the other reports.
Once I have converted to excel then I need to present the data in word (both with the Table and with the summary as seen in the picture).
Is there any way I can automate or semi automate this? Unfortunately having the pdf/excel format changed is not an option. The only way I could think is some sort of mail merge but I don't know how to do a dynamic amount of lines vs creating 1000 documents lol.
I might be spending the next few days of my life just doing this all manually once that big one comes in but i will be forever grateful if someone has another idea.
Thanks in advance!!
Picture was to large to upload
. Apologies for the cell phone screenshot cant access this site on my work computer.
