I’m currently stuck with a process where “For Each Row” I need to “Copy from Range” a cell in column B (Example “B4”) and then paste it into another column and save the excel file as PDF. After this is done I need to go back to the Copy from Range step and then copy B5 and do the process al over again. And so on, so after B5 would be B6 and then B7 etc.
It does everything I need to do but I can’t find a formula that starts the “Copy from Range” again from a different row in Column B.
Does anybody have experience with this? Or have a formula that can execute these tasks?
I have an order number in “sheet3” in column B. Each row represents a different Order number and I need to copy the value (For example from B4) to “sheet1” B1 and then convert to pdf. Then I need to copy a new order number from “sheet3” (for example from B5, B6, B7 etc.) to “Sheet1” B1 and then convert that to PDF and so on.
The way the excel is set up now is that the value that is copied from “sheet3” column B to “sheet1” B1 generates an invoice in “sheet2”. This invoice from “sheet2” needs to be saved as PDF. Every value represents an invoice for a different client.
It already saves the PDF files with different names so everything for this is set up. The only thing missing is copying from each row.