Excel Report Template

customaware

I have the need to do an Excel Report template.

The first column will be a row number ... 1,2,3... etc So this can be a formula A3=A2+1 etc
The second Column is a constant piece of text .... in fact a Debit Account Number
The third Column is a constant piece of text ..... a set Payment type.
In the 4th Column I place the LIST_TABLE_START
In Columns 5-9 are <<BO.Attr>> tags from the DB
In Column 10 is the LIST_TABLE_END()

Row 1 has the Data already entered for Cols 1 thru 3.
The data from the DB works perfectly for cols 4 thru 10
But cols 1 thru 3 are empty

Can anyone suggest a way to get Columns 1,2,3 to repeat from the 1st Row for all the records that are inserted from the BD?

Jaymer

startup macro.
define the range for cols 1,2,3
copy cells down

unless you add cols 1-3 as merge output from Aware

tford

unless you output those columns yourself

I'm assuming Jaymer is suggesting that your LIST_TABLE could include columns 1-3