Macro for specific multiplication of columns

Hi all,

I'm looking for a macro that will help me accomplish the following:

In column B, I have numerical values that range from -10 to 10.
In column C, I have one of two values: 1, or 2.

What I'd like is:
If the value in column C is 1, then multiply the value in Column B by -1.
If the value in column C is 2, then multiply the value in Column B by 1 (do nothing).

And these values should populate column C, and clear column B.

So what this would look like on a sample:

Before:
B1: 6 C1: 1
B2: -4 C2: 2
B3: 1 C3: 2
B4: 5 C4: 1

After:
B1: empty C1: -6
B2: empty C2: -4
B3: empty C3: 1
B4: empty C4: -5


Thanks for any help!

@hakerman2,

I'm getting a compile error: variable not defined when I try to run it.

I should also mention, for future reference, that not all cells in columns A and B contain numbers, some contain a string of text like "abc".

Same error

@mehmetcik

Thanks, although if I run this on columns A and B, this populates C, im looking to replace the cells in B.
What modifications should be made to change that?

@mehmetcik

I am also getting the same compile error (variable not defined) when using option explicit

@bakerman2, oh ok I see. I'm now running into the same issue where the macro outputs the values into column C, and deletes column B. I want the values to be in column B, and the values in column A to be deleted.

@mehmetcik, hmm the macro isn't doing anything now

Please Login or Register  to view this content.

mehmetcik,
OP said,

Originally Posted by tisahardknocklife

I should also mention, for future reference, that not all cells in columns A and B contain numbers, some contain a string of text like "abc".

However, OP didn't mention what to do when such cell(s) found, so my code is just populating Error in the cell.
Only my guess...

Please Login or Register  to view this content.

@bakerman2, thank you, that's exactly what I was looking for!

quick question--how can I modify it to multiply different columns?
e.g. instead of A and B, if I wanted to multiply columns D and E?

That worked, thanks.

Don't mention it, you deserve it!