jackson1990
Board Regular
- Joined
- Feb 21, 2017
- Messages
- 56
Hey everyone,
I've got one that has kind of stumped me. I have about 50 rows of data 170 columns of data. I am trying to figure out a way that I can take that and create a PDF document for each row that has formatting set up by me. So basically the system to export 50 PDF's (one for each row) in a pre-defined format (that I have created).
So for instance my data looks like this:
And I want it to output a PDF that would look like this (obviously in a PDF but just to give you an idea):
Company Name: Company A
Contact: Jon
Metric: $100k
Comments: N/A
Any thoughts on the best way to do this? I'm open to all ideas it doesn't have to be just executed in excel, could be a mishmash of programs.
Thanks!
I've got one that has kind of stumped me. I have about 50 rows of data 170 columns of data. I am trying to figure out a way that I can take that and create a PDF document for each row that has formatting set up by me. So basically the system to export 50 PDF's (one for each row) in a pre-defined format (that I have created).
So for instance my data looks like this:
Company Name | Contact | Metric | Matrix Question A | Matrix Question B | Comment |
Company A | Jon | $100k | Option A, Option B | Option B, Option D | N/A |
Company B | Rob | $150K | Option B, Option C | Option A, Option D | N/A |
And I want it to output a PDF that would look like this (obviously in a PDF but just to give you an idea):
Company Name: Company A
Contact: Jon
Metric: $100k
Options | Matrix Question A | Matrix Question B |
Option A | x | |
Option B | x | x |
Option C | ||
Option DD | x |
Comments: N/A
Any thoughts on the best way to do this? I'm open to all ideas it doesn't have to be just executed in excel, could be a mishmash of programs.
Thanks!