Drag data all the way to the last data in the next column

Hello,

I'm newbie and recording a macro. Could you advice which code i should use to drag data from eg:N1(Unit) all the way to the last data in the next column. For example there are 2 column, Unit & Age. I want to drag the word 'Unit' all the way down untill the last row for age.

Before After
Unit Age Unit Age
0-20 Unit 0-20
251++ Unit 251++
251++ Unit 251++
251++ Unit 251++
0-20 Unit 0-20
0-20 Unit 0-20
0-20 Unit 0-20
0-20

Take note the last data in column Age will fluctuate on daily basis as the data is not fixed.

Drag data all the way to the last data in the next column - auto

Hi,

A sample workbook could help us understand better what you need.

If you want to copy "pce" down, you can use the macro recorder.

Unit Age
pce DUMMY
DUMMY
DUMMY
DUMMY
DUMMY

Excel will then provide following macro :
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:A11")

sub sample
Dim rgStart As Range
Dim rgTarget As Range
Dim lFinalRow As Long
Set rgStart = Range("A2") ' where unit lays is in column A

' find the last row of next column
lFinalRow = Cells(Cells.Rows.Count, rgStart.Offset(, 1).Column).End(xlUp).Row

' determine the range to fill
Set rgTarget = Range(rgStart, Cells(lFinalRow, rgStart.Column))

' autofill the Start Range value into the target range
rgStart.AutoFill Destination:=rgTarget
end sub