| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
| How to fill a blank cell down to a filled cell | Excel Worksheet Functions | |||
| Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
| fill all cells in row with one cell entry | New Users to Excel | |||
| How do I auto fill long col. filling blanks with last filled cell | Excel Discussion (Misc queries) | |||
Linear Mode
