| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill multiple values in multiple cells
I have a spreadsheet with about 18000 lines of data containing multiple
values and blanks beneath each value. Is there a way to auto copy and paste the value directly beneath each value until you reach the next value? ie. Line 1 has a value of 1050 Line 2 to 5 in blank. I want these to have the value of 1050 Line 6 has a vlue of 10654 Line 7 to 18 are blank. I need these to have the value of 10654 Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill across multiple worksheets | Excel Discussion (Misc queries) | |||
| Auto fill multiple worksheets | New Users to Excel | |||
| fill down multiple cells in the same column | Excel Worksheet Functions | |||
| Auto fill multiple cells depending on single cell value | Excel Worksheet Functions | |||
| Auto fill multiple sections with different names | Excel Discussion (Misc queries) | |||
![Matt M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
