Description: I have 2 sheets first sheet is kinda template sheet that I want to be used each time for each file. Now, to fill this sheet it should take data from the other sheet where the data is all organized in columns. I want it to make pdf for each row after all the desired cells are filled, by naming them differently from each other but in more customized way like "invoice company to company currency XXXXX" the X part should change all the time according to a specific cell in each row.
I hope you get my point if not kindly ask me I will explain. I have attached some images for better understanding.