+ Reply to Thread
Results 1 to 3 of 3

Insert new column and conditionally copy and paste values

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Bnglr
    MS-Off Ver
    Excel 2007
    Posts
    25

    Insert new column and conditionally copy and paste values

    Hello All,

    Hope all of you doing great...

    I am having a data sheet which includes some details regarding few projects. I would like to create a macro for the same as i have to do it in a regular basis.

    The requirements are;

    1. Insert a column after 'C' and the column heading should be the same as 'C'
    2. If the cell showing 'Not Available', then copy the cell value from column 'B' and paste it to the newly incerted column
    3. For others, copy the same values from 'C' and paste it to the newly inserted column


    Thanks in advance....
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    re: Insert new column and conditionally copy and paste values

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-03-2013
    Location
    Bnglr
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Insert new column and conditionally copy and paste values

    Thank you so much mate... its working..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. conditionally copy formulas and paste their values based on columnA
    By cmmchick in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-29-2013, 05:02 AM
  2. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  3. [SOLVED] Insert three formulas one in each column paste values
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2012, 12:10 PM
  4. More efficient script for insert new worksheets, copy and paste values?
    By SDBoca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2011, 11:07 AM
  5. Insert blank column and copy/paste values
    By eonizuka in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2009, 01:05 PM

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