Macro to calculate % then multiply by another cell

[Rosanna Lam]

Hi,

I need a macro in column D to calculate the % for column B&C and then multiply it by a number in column A (number may change). I have been manually doing the calculations every month with over thousand of records. Is it possible to do it?

Attached please find the sample file. Thanks.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Rosanna Lam]

It works!......THANK YOU VERY MUCH!!!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[Rosanna Lam]

Hi, John:

When the macro runs to the end of my file, there's an error message (Run-time error "13": Type mismatch) and the "ActiveCell.Offset(, 3).Value = ActiveCell.Offset(, 1).Value / z * y" is highlighted. Can you please let me know how to fix it? Thanks.

[JOHN H. DAVIS]

Rosanna:

When I test it on the sample provided, I can't duplicate the error. Can you provide a sample where it errors?

[Rosanna Lam]

Thanks, John. Please see attached.

[JOHN H. DAVIS]

OK try:

Please Login or Register  to view this content.

[Rosanna Lam]

Thank you!!!

[JOHN H. DAVIS]

You're welcome.