Inserting a formula to a column but....

[puuts]

Hello,

I have a formula to be inserted in a Column but the formula to be inserted will be parallel on the other Column.

The formula to be inserted is: =G + H

What i mean is, If Column M, let say M2:M30 (excluding the header), then the formula will be inserted in Column O2:O50.

I have attached the sample workbook.

[JOHN H. DAVIS]

Not sure I understand, does this help?

Please Login or Register  to view this content.

[puuts]

Hi John,

That's what I'm looking for . The below formula is what I'm using, but i get error when modifying your code:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[puuts]

Hi John,

Thanks for that, but the formula is just pasting it, and not calculating... do you have any idea why is like that?

[JOHN H. DAVIS]

Is the Country Splits workbook open? Try selecting Column O then Data>Text to Columns>Finish and see what happens.

[puuts]

I've figured it now. Thank you John! Your the best!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.