I need help trying to figure out how to automatically take a spreadsheet and output that spreadsheet into another layout that is specific to a program I need to import into. I have created a macro by recording my steps and copying these fields, but I am hoping to build something configurable and easy to use as I deal with different variations of input data. I am visualizing a worksheet that contains the ability to select the input data (opens windows file select box), select the output file (opens windows file select box), select the output file location, possibly having the headers from the input and output file listed in the same worksheet, then being able to map these fields to each other. The final step would be to output the data into the output file based on the mapping or generate a new file to a specific location.

Is this even possible? Or is there some type of free or reasonably priced software available that will do this. I am new to macros/vba and have the slightest clue where to begin. By recording one macro, I was able to replicate each column I needed to copy into the output file, but I would have to have to code for each variation of data and output.

Thank in advance for feedback.