Hello everyone
I am searching for an easy way (using arrays if poosible) to copy non contiguous columns from Source sheet to Destination sheet
In Source sheet that data has headers (I don't want to depend on the headers) the data starts at row 6
and in the destination sheet, the data would start at different row which is 10 >> I need the copied columns in different columns ..
for example:
Range("A6:A22") in source sheet would be in Destination sheet range("F10:F26") and the same with other columns
I imagine to have two arrays for column numbers and from these arrays it would be flexible to copy any column in the source sheet to any column in destination sheet
SourceArray=array(1,2,3,4,5) 'The original column numbers in source sheet
DestinationArray=Array(6,5,7,4,3) 'The new columns in destination
Hope it is clear
Bookmarks