Hi, you don't need a macro to do that, just follow these instructions:
Select de Range with the Data (CTRL+A), then Edit-Go to (CTRL+G), then
Special-Blanks and click OK. Now press F2 and write =CR where CR- the column
and row from which you want to replicate (copy) the data, for instance =A1,
and press CTRL+Enter and that's it, your data will be copied as you wanted.
--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"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