Example data:
Site EmpID WeekEndingDate Agent Calls Ans
Teatown ab777t ___________ Bob Brown 200
Boxville cc221m ___________ Sister Sue 800

**This is weekly info so the rows vary.

I need a macro to auto fill the WeekEndingDate from a date that I enter each
month on another tab.

Thank you soooo Much!!

Sub Auto_Fill()
Dim lRow As Long
With ActiveSheet
.Range("C2").Value = Sheets("Sheet2").Range("A1").Value
lRow = .Range("B" & Rows.Count).End(xlUp).Row
.Range("C2:C" & lRow).FillDown
End With
End Sub


Gord Dibben MS Excel MVP


On Thu, 29 Oct 2009 10:46:12 -0700, drober
wrote:

Example data:
Site EmpID WeekEndingDate Agent Calls Ans
Teatown ab777t ___________ Bob Brown 200
Boxville cc221m ___________ Sister Sue 800

**This is weekly info so the rows vary.

I need a macro to auto fill the WeekEndingDate from a date that I enter each
month on another tab.

Thank you soooo Much!!