Question: how to copy multiple non adjacent cells in excel vba?
Answer: Copy the data from sheet1 to sheet2 to exactly the came cell addresses (not very useful)
Copy the non-continuous data from sheet1 to sheet2 in adjacent columns.
Copy the non-adjacent data from sheet1 to sheet2 in adjacent rows one below the other.