asked on

Help on VBA request

Hello the experts,

Im working on my Travel expanses workflow and was able to get pretty much all I needed done with VBA, except this part where your help will be very welcome, pretty please :)

Suppose columns F, G, H

Column F is full of "C" or "D"
Column G is full of numbers
Column H is empty

I want that IF it's a "C" in F, then the number in G is moved from G to H, for all the column (no more than 500 rows max, different number of rows each time)

Thank you very much for your help !

Kind regards,

Mélanie
macro-should-do-this.png

ASKER CERTIFIED SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Magpie Bavarde

ASKER

Hello Norrie,

That's perfect and works like a charm !

Thank you very much for your kind help :)

Best regards,

Mélanie

SOLUTION

Noah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Magpie Bavarde

ASKER

Hello Noah and thank you very much,

Works like a charm too - and I can actually understand this one ^^ (but I will try to understand the previous one too as there is no better way to learn and progress)

Only thing that bothers me is that in both case, the macro will erase any number already present in column H

But I will launch another topic for that

Thank you very much & Kind regards

Mélanie

Norie

Mélanie

What should happen if there is an existing value in column H?

Magpie Bavarde

ASKER

Hello,

I've launched another topic as I understand you're only "rewarded" once per topic

Is that the right thing to do or should I have continued the discussion here for my second request ?

Thanks & Kind regards,

Mélanie