| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill function
If I've had a report downloaded out of Oracle/Discoverer into an Excel
spreadsheet, and forgotten to inform the system that I need the transaction identifier number repeated against every distribution line (so that the Excel spreadsheet only includes that number against the first line of the transactions), is there a "Fill" function that I can use to populate the blank lines with the first line transaction number? i.e. if the space below is blank, fill it with the last number above, until you meet a populated space, whereafter you do the same process but taking the new value of the populated space, until you reach the end of the report. [OK - I agree that it would be better to go back and change the report and re-run it, but that is not always possible!!] -- Geoff |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill function
Try Debra Dalgleish's page for ways to fill in the col blanks:
http://www.contextures.com/xlDataEntry02.html Excel -- Data Entry -- Fill Blank Cells Fill Blank Cells Fill Blank Cells Programmatically (Sub FillColBlanks() by Dave Peterson) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Geoffric" wrote: If I've had a report downloaded out of Oracle/Discoverer into an Excel spreadsheet, and forgotten to inform the system that I need the transaction identifier number repeated against every distribution line (so that the Excel spreadsheet only includes that number against the first line of the transactions), is there a "Fill" function that I can use to populate the blank lines with the first line transaction number? i.e. if the space below is blank, fill it with the last number above, until you meet a populated space, whereafter you do the same process but taking the new value of the populated space, until you reach the end of the report. [OK - I agree that it would be better to go back and change the report and re-run it, but that is not always possible!!] -- Geoff |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill function
Thank you, Max. The function on the site you recommended was exactly what I
wanted. This will save me hours of work! Thanks again. -- Geoff "Max" wrote: Try Debra Dalgleish's page for ways to fill in the col blanks: http://www.contextures.com/xlDataEntry02.html Excel -- Data Entry -- Fill Blank Cells Fill Blank Cells Fill Blank Cells Programmatically (Sub FillColBlanks() by Dave Peterson) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Geoffric" wrote: If I've had a report downloaded out of Oracle/Discoverer into an Excel spreadsheet, and forgotten to inform the system that I need the transaction identifier number repeated against every distribution line (so that the Excel spreadsheet only includes that number against the first line of the transactions), is there a "Fill" function that I can use to populate the blank lines with the first line transaction number? i.e. if the space below is blank, fill it with the last number above, until you meet a populated space, whereafter you do the same process but taking the new value of the populated space, until you reach the end of the report. [OK - I agree that it would be better to go back and change the report and re-run it, but that is not always possible!!] -- Geoff |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill function
Welcome, Geoff.
Good to hear that. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Geoffric" wrote in message ... Thank you, Max. The function on the site you recommended was exactly what I wanted. This will save me hours of work! Thanks again. -- Geoff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a function that skips a cell in a fill? | Excel Worksheet Functions | |||
| FILL FUNCTION NEEDED | Excel Discussion (Misc queries) | |||
| Fill Function to next Column | Excel Worksheet Functions | |||
| Fill Color with Keyboard Function | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Hybrid Mode
