LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default filling in empty cells -

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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling a series into a non-empty column Kathleen Excel Worksheet Functions 1 August 18th 07 05:47 PM
Help on filling empty cells with string + row() John Smith Excel Discussion (Misc queries) 1 July 14th 06 04:44 AM
Filling empty cells with a value Ian Richardson ACITP Excel Discussion (Misc queries) 4 May 17th 06 03:25 PM
Filling in empty cells in columns koba Excel Discussion (Misc queries) 2 November 8th 05 10:03 PM
Excel - Autom. Filter "Empty / Non Empty cells" should come first Rom Excel Discussion (Misc queries) 0 August 10th 05 04:32 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"