branston
10-02-2019, 07:27 AM
Hi
I am trying to copy a range of cells (names only) and save/paste those ranges as 4 seperate pictures ideally within the same worksheet (or another tab if easier).
At the moment I can only export Set 1 as a picture and the range is "fixed". The range being fixed is a problem as the range of each list can change length. Ideally I would like one macro rather than 4 do this task.
I've attached my sheet and would appreciate somebody taking a look. Not sure I am tackling this the right way and/or maybe there is a better way to do it.
TIA
I am trying to copy a range of cells (names only) and save/paste those ranges as 4 seperate pictures ideally within the same worksheet (or another tab if easier).
At the moment I can only export Set 1 as a picture and the range is "fixed". The range being fixed is a problem as the range of each list can change length. Ideally I would like one macro rather than 4 do this task.
I've attached my sheet and would appreciate somebody taking a look. Not sure I am tackling this the right way and/or maybe there is a better way to do it.
TIA