Enter the formula in say J2
=J1

Select column A.
Press F5. Click Special
From GoTo window select Blanks.
Right clickPaste SpecialFormulas..

If this post helps click Yes
---------------
Jacob Skaria


"Dave Shultz" wrote:

I want to write a macro to copy down €œHoliday€� in column A until the row
where €œVacation€� appears. And then copy down €œVacation€� in the subsequent
rows. And the in column B, I want to copy down €œTeam A€� until the next team
is mentioned. However, I dont want the macro applied to the columns where I
have the # of hours listed.

Suggestions?

Type Team Name Jan Feb Mar Apr
Holiday Team A Tom 16 8
Dick 16 8
Harry 16 8 12
Team B Sue 16
Kim 16 8
Sam 16 8
Team C George 16 8
John 16 8
Jim 8
Vacation Team A Tom 8
Dick 8
Harry
Team B Sue 8
Kim
Sam 8
Team C George 8
John 8
Jim