creating a table with numbers divisible by 12

[Guest]

Is there a formula to create a table that has numbers that are divisible by
12. I created one by having a sequencial number in one column and then a
formula in the next column
=sum(b1*12) and in b1 is 1. In next row =sum(b2*12) and in b2 is a 2.. etc.
Is there an easier way to do this. I need to create a table that goes out to
about $300,000

 

[Myrna Larson]

Put 12 in B1. Put 24 in B2. Select B1 and B2, then drag the fill handle (the
little black square at the lower right corner of B2) down.

 

[Myrna Larson]

Another way. Put the number 12 in a cell. Select that cell. Then Edit/Fill
Series, and set the step value as 12.

 

[duane]

that's like 30,000 rows or so....

a macro can do this dog work

sub macro()
for i=1 to 50000
max = 300000
' change 300000 to whatever you want
'change cell location to wherever you want
cells(i,1) = 12*i
if cells(i,1) >max then goto alldone
next i
alldone:
end su

 

[Myrna Larson]

Isn't that harder/more time consuming than Edit/Fill/Series <g> ?