ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Fill cells below until next cell is filled (https://www.excelbanter.com/excel-worksheet-functions/170479-fill-cells-below-until-next-cell-filled.html)

JKeef

Fill cells below until next cell is filled
 
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

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


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com