Thread: Fill cells below until next cell is filled
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Fill cells below until next cell is filled
Debra Dalgleish shares some ways:
http://contextures.com/xlDataEntry02.html

JKeef wrote:

Hi- I have an Excel document that is set up like word doc. I am trying to get
the unique customer number on all lines to keep the data together. Is there a
way to auto fill the blanks until you hit the next customer, then auto fill
the next group with that number and so on?

--

Dave Peterson
Reply With QuoteReply With Quote