creating a table with numbers divisible by 12

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Another way. Put the number 12 in a cell. Select that cell. Then Edit/Fill
Series, and set the step value as 12.
 
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
 
Back
Top