a simple way to spread a number evenly in 12 columns

[Jeanne]

In column a through l I have a heading for each month, jan to dec. In column
m I have a dollar figure that I want to spread evenly over the 12 months. I
have 4,000 row of data that I need to apply this to. Is there an easier way
that putting =m1/12 in column a and then copy/paste special in the other 11
columns?

 

[duane]

if you dont' want to copy it yourself

if 1st row is 2

for i = 2 to 4000
for j = 1 to 12
cells(i,j).value = cells(i,13).value/12
nexy j
next i
end su

 

[Ron Rosenfeld]

In column a through l I have a heading for each month, jan to dec. In column
m I have a dollar figure that I want to spread evenly over the 12 months. I
have 4,000 row of data that I need to apply this to. Is there an easier way
that putting =m1/12 in column a and then copy/paste special in the other 11
columns?

Assuming your month heading is in row 1:

Select cell A2
Edit/GoTo Reference L4000 <shift> OK

That will select the range A2:L4000

Now put the cursor in the function bar and enter the formula:
=$M2/12 <ctrl><enter> (Hold down the <ctrl> key while hitting
<enter>)

The formula, properly adjusted for position, will be copied into each cell.

Takes twenty times as long to write this as to do it



--ron