Hi Team,
Hoping there are some Excel gurus amongst us who may we able to assist.
I'm creating a macro enabled Excel file that allows you to paste a monster stat-block into it. It rips the paste apart applying all the formatting requirements in line with a standard 5e stat-block and then copies the text into a table.
The intention is that table would then be loaded into the CSV to RW Import Tool. I'm basically trying to make it as efficient as possible to get monsters from a PDF into RW fully formatted.
And I'm close. I have it all working except the final step where I need to copy the formatted cells into a table.
I can copy the values and I've got it working so that it will copy the text in as BOLD.
The challenge I've yet to overcome however is pasting the data in where a single cell contains BOLD, ITALICS and NORMAL text. Monster Attacks obviously have this type of formatting.
Here's the file in case anyone knows the answer. Once done this will be something I upload for the community.
https://drive.google.com/file/d/1gUM...ew?usp=sharing
1. Paste monster stat-block from PDF (note, need to move text to correct lines)
2. Press the button
3. Monster stat-block is converted into format compatible with the CSV to RW Importer
This is where it's going wrong. As you can see I have the formatting working in the Actions 1 cell at the top. This line is then copied into the next available line on the table. It's applying BOLD to the whole line instead of copying the formatting from the source cell.
