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?