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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com