Fill function

[Geoffric]

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!!]

 

[Max]

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)

 

[Geoffric]

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

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)

---

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!!]

 

[Max]

Welcome, Geoff.
Good to hear that.