I have ssheet that column A is a list of headings, column B is empty and Column C onwards have data that relate to the headings.
I need to copy and Paste Column C into Column B and print. Then copy Column D into B, Print and so on so forth until the loop reaches an empty column.
Can this be looped rather than manually recording a tedious vba coding. If so how?
Many thanks
I need to copy and Paste Column C into Column B and print. Then copy Column D into B, Print and so on so forth until the loop reaches an empty column.
Can this be looped rather than manually recording a tedious vba coding. If so how?
Many thanks