I have programmatically copy/paste Range ("A1:B4") from Sheet1 to be pasted
on Sheet2.
However, on Sheet2, I want A2:A4 to display the same date as in A1,meaning populating the cells in Column A, where there is a non-Empty cell in Column B.
Any suggestion on how to code it, making the transfer to Sheet2 more complete with dates for each item on Range("B2-B4") appearing on Sheet2?
COLUMN A COLUMN B
12-10-17 (CellA1) Apple(CellB1)
Orange(CellB2)
Mango(CellB3)
Papaya (CellB4)
on Sheet2.
However, on Sheet2, I want A2:A4 to display the same date as in A1,meaning populating the cells in Column A, where there is a non-Empty cell in Column B.
Any suggestion on how to code it, making the transfer to Sheet2 more complete with dates for each item on Range("B2-B4") appearing on Sheet2?
COLUMN A COLUMN B
12-10-17 (CellA1) Apple(CellB1)
Orange(CellB2)
Mango(CellB3)
Papaya (CellB4)