K
Khalil Handal
Is there a way to copy a range of non adjasent cells from one sheet to
another without moving back and forth between the 2 sheets?
i.e.
copy D15 from sheet1 to K17 in sheet2
copy G10 from sheet1 to M17 in sheet2
copy range starting E21 until first empty line from sheet1 to colomn I in
sheet2 starting the first empty line in that colomn.
copy range starting C21 until first empty line from sheet1 to colomn F in
sheet2 starting the first empty line in that colomn.
another without moving back and forth between the 2 sheets?
i.e.
copy D15 from sheet1 to K17 in sheet2
copy G10 from sheet1 to M17 in sheet2
copy range starting E21 until first empty line from sheet1 to colomn I in
sheet2 starting the first empty line in that colomn.
copy range starting C21 until first empty line from sheet1 to colomn F in
sheet2 starting the first empty line in that colomn.