I am trying to update a Vendor name and create an output xlsx file for each vendor. Below is a snapshot of what it should look like, and I want to create a new file for each vendor while preserving the formatting above the updated value.
I must not be using Preserve Formatting on Overwrite properly as this doesn't seem to be working for me
Trying to keep A1:J2, only update a3 value
I think the problem is while I'm specifying what to overwrite, it isn't able to use that to create a new file name and is creating sheets instead in the same file.
I would like to avoid using multiple basic tables to merge columns if possible so any workaround is greatly appreciated.
