copy certain rows into columns

[missy22]

I am currently new in using excel VBA and require some assistance.
I need help in creating a excel VBA macro which can extract specific ranges and paste it into a new column.

I have following table (price – A column, cvr_price - B Column, price_type - C column) below:

Price Cvr_Price Price Type
99.945 CVR
99.35 TALK
99.32 CVR
46a TALK
99.21 TALK
99.235 CVR
100.226 CVR


I would like to extract all the CVR’s prices and paste them into column B (Cvr_price).

The output should look like the following below:
Price Cvr_Price Price Type
99.945 99.945 CVR
99.35 TALK
99.32 99.32 CVR
46a TALK
99.21 TALK
99.235 99.235 CVR
100.226 100.226 CVR

I would like to know how can i do this using excel vba as I tried writing an if statement function but does not do what i want.

If anyone could provide me with some assistant, i would be very grateful.

Thank you.

[arlu1201]

You do not need a macro for it.

In cell B2, put this formula and then drag down -

=IF(C2="CVR",A2,"")

[missy22]

thank you so much for your help...i did not expect it would be so simple.

thank you for your time and response.

kind regards
misbah

[arlu1201]

Am glad it worked.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save