VBA, How to make data dynamic growing along with another sheet

[Guest]

Hi
How to program/name so that data growing along with other sheet. For example
the "date" column with grow with "date" column at other worksheet?
Thanks
Daniel

 

[Guest]

Let's say the date column is in Column A.

Dim myRange as range
Dim lRow as long
Dim aWS as worksheet
set aWS = activesheet 'Change as needed
set myrange = aws.range("A1") 'Change as needed
lRow = aws.cells(aws.rows.count, myrange.column).end(xlup).row
set myRange = myrange.resize(lrow - myrange.row + 1, 0)