Hello,
i'm trying to build a macro and assign it to a button to:
- copy/paste selection value
from sheet1 range A2:E4 based on a number in colomn F(cell F2)
to sheet 2
- copy/paste selection value
from sheet1 range A5:E7 based on a number in colomn F(cell F5)
to sheet 2
and continue like this.
if there is nothing in colomn F(cell F..) just to pass it and move forward.
for copying i want to be copied like this in sheet 2
for example
5 times for A2:E4 range from sheet1
2 times for A5:E7 range from sheet1
to copy like this in sheet 2
1.1-A2:E4
1.2-A5:E7
1.3-A8:E10
1.4-A11:E13
1.5-A14:E16
2.1-A17:E19
2.2-A20:E22
Thank you very much in advance for the time and help.
Best Regards
D.D.
Bookmarks