Results 1 to 4 of 4

copy certain rows into columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    196

    copy certain rows into columns

    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.
    Last edited by missy22; 08-08-2012 at 07:10 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1