Making a table

[Kepler]

Hi,

Given some results, I want to build a table in Excel. How can I do this? The first line, from A1:J1 will have a content in each cell; A2:J2, A3:J3, etc...will have similar formula contents. The process must be conducted by an IF statement ( otherwise it would fill the entire sheet).

Can anyone help me out?

Kind regards,

Kepler

[Don Guillett]

Sometimes the macro recorder can be your friend. To show you, I just
recorded this
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 12/10/2005 by Don Guillett
'

'
Range("H1:I1").Select
Selection.AutoFill Destination:=Range("H1:I10"), Type:=xlFillDefault
Range("H1:I10").Select
End Sub

which may then be refined by removing selections
Sub filldown()
Range("H1:I1").AutoFill Range("H1:I10")
End Sub

You would have to give more info on what determines the last row to fill to
such as

lastrow=cells(rows.count,"a").end(xlup).row
Range("H1:I1").AutoFill Range("H1:I" & lastrow)

--
Don Guillett
SalesAid Software
[email protected]
"Kepler" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> Given some results, I want to build a table in Excel. How can I do
> this? The first line, from A1:J1 will have a content in each cell;
> A2:J2, A3:J3, etc...will have similar formula contents. The process
> must be conducted by an IF statement ( otherwise it would fill the
> entire sheet).
>
> Can anyone help me out?
>
> Kind regards,
>
> Kepler
>
>
> --
> Kepler
> ------------------------------------------------------------------------
> Kepler's Profile:
> http://www.excelforum.com/member.php...o&userid=29328
> View this thread: http://www.excelforum.com/showthread...hreadid=492401
>