I am copying specific cells in a row to be pasted in another workbook, however, I want to post the cells in a different order than how they were copied.
This is part of the Select copy code
For i = 2 To LastRow
If Cells(i, 9) > 0 Then
Union(Cells(i, "Q"), Cells(i, "V"), Cells(i, "P"), Cells(i, "H"), Cells(i, "I")).Select
But when I'm pasting to the other sheet, I want Column I Cell Data to go into Column A
Column H to Column B
Column Q to Column C
Column V to Column D
Column P to Column E
How do I arrange this uing VBA . Excel 2003