How do I take an excel file with multiple rows and turn each row into its own file?

Question

I'm trying to take the input excel file and get it to fit into the end file while maintaining the format of the end file.

in other words, I want to take the cell A6 from file input and put it in C5 in the end file, cell G6 from file input and put it in C8 in the end file.. so on and so on across the row and save that as a file.

Then, go down a row in the input file and do it all over again and save it as a completely new file. A7 to C5, G7 to C8

file input.xlsx

end file.xlsx

Blewis21 · Answer

Never mind, I figured it out.

thanks for trying

Blewis21 · Answer

If I can understand 1 cell, I should be able to figure out the rest.

based on the picture,  I really just need to copy the value of G6 and paste it into C8 and Save it as a new file.

excel to excel.PNG

mceleavey · Answer

@Blewis21 , I feel your pain.

It would be easier to post a raw file that you get, and the required output. I found the explanation confusing...

M.