Jacob -
Yes that did work... Thanks... I have no Idea why it worked but hey, it's
all about results -

"Jacob Skaria" wrote:

It should be...

Enter the formula in say D2
=D1
Copy cell D2
Select column A.
Press F5. Click Special
From GoTo window select Blanks.
Right clickPaste SpecialFormulas..

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


"Jacob Skaria" wrote:

Just give this try..

Enter the formula in say D2
=D1

Select column A.
Press F5. Click Special
From GoTo window select Blanks.
Right clickPaste SpecialFormulas..
--
If this post helps click Yes
---------------
Jacob Skaria


"stumped-in-excel" wrote:

When I download a database into excel - it sets up the data fields as follows:

company name person
Acme Smith
Jones
Brown
Bender Howard
Mason
Fortune
Black Rain


Is there a way to auto fill the blanks with the company name above?

so it looks like

company name person
Acme Smith
Acme Jones
Acme Brown
Bender Howard
Bender Mason
Bender Fortune
Black Rain


any help would be appreciated!