Need a Macro for division

[talisman77]

I have a column of 480 numbers that needs to be divided by the column to the right of it also containing 480 numbers.

I don't know how to write a macro so any help would be greatly appreciated!

Thanks,
Bob

 

[jfish1288]

talisman77, when you select cell IN5 do you see "=IL5/IM5" in the formula bar?

 

[kpark91]

Like comfy said before.

You must not just copy + paste the formula but
1) just put in IN4's cell this:

=IL4/IM4

2) ENTER
3) Use your mouse to select the cell IN4.
4) Put your cursor to the bottom right corner of the selected cell until cursor turns into black cross.
5) Click + Drag when the cursor is black cross and then DRAG DOWN to the cell IN5.
6) Confirm that in IN5, you have =IL5/IM5 and it outputs the desired result.
7) Click + Drag to the rest of the cells repeating step 1 to 5.

 

[talisman77]

jfish1288....
Yes..after I put the formula in cell IN4 then copy it all down to row 408, it does give sequential numbering in the formula bar....The problem is that the answer to all the cells is the same answer that I get in cell IN4....

kpark91....
I tried what you just said but it made no difference...I still get the same answer that is in cell IN4 in each cell although in the formula bar, it does go from =IL4/IM4 to =IL5/IM5 to =IL6/IM6 and so on

 

[kpark91]

Ok. So, we know the "copying down" works.

Try checking if you workbook calculation is set to automatic instead of anything else.
To do that, go to

Excel Top-Left button > Excel Options > Formulas > Workbook Calculation

 

[talisman77]

kpark91...
And there lies the problem....You solved it and it all works great!

I want to thank all of you that chimed in here especially Comfy and kpark91!

You guys stuck with me, spent a lot of time with me and I really appreciate it.

Sincerely,
Bob