twhitehead
New Member
- Joined
- Jun 28, 2012
- Messages
- 8
I am trying to create a macro that will copy the date entered in sheet 1 cell A10 to sheet 2 B1 and copy down Column B: as long as there is data in sheet 2 column A.
i.e date 16/06/2012 in cell A10 in sheet 1
Sheet 2
A1 VH-123
A2 VH-XYZ
A3 VH-QWY
etc
I would like to copy 16/06/2012 to b1 and keep copying it down as long as the cell in adjacent in column A is not blank
So it will look like this, but if there is data in A1..A10 it will copy date from B1..B10
Sheet 2
A1 VH-123 B1 16/06/2012
A2 VH-XYZ B2 16/06/2012
A3 VH-QWY B3 16/06/2012
i.e date 16/06/2012 in cell A10 in sheet 1
Sheet 2
A1 VH-123
A2 VH-XYZ
A3 VH-QWY
etc
I would like to copy 16/06/2012 to b1 and keep copying it down as long as the cell in adjacent in column A is not blank
So it will look like this, but if there is data in A1..A10 it will copy date from B1..B10
Sheet 2
A1 VH-123 B1 16/06/2012
A2 VH-XYZ B2 16/06/2012
A3 VH-QWY B3 16/06/2012