+ Reply to Thread
Results 1 to 3 of 3

VBA If Column contains values, copy and insert row beneath

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    55

    VBA If Column contains values, copy and insert row beneath

    The first sheet is how it looks. The second is the process i want the macro or vba script to perform until everything is in only columns A and B Attachment 274614Attachment 274615

    It needs to search Column C for a value and if it finds a value copy the row header; insert a new row with this row header and paste the value of the found cell. I am extremely new with writing VBA script but I am working on tweaking what I can find online. Any help is greatly appreciated!

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: VBA If Column contains values, copy and insert row beneath

    Hi, Aquabat,

    you should consider to attach a workbook with the data as opposed to just showing pictures.

    One possible way to do it:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    01-25-2013
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: VBA If Column contains values, copy and insert row beneath

    Thank you! It worked swell!

+ 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. [SOLVED] VBA If row contains values, copy and insert row beneath
    By Aquabat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2013, 11:06 AM
  2. [SOLVED] Insert new column and conditionally copy and paste values
    By kriahnadas.oo7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 10:07 AM
  3. [SOLVED] Fill in missing values of one row with the rows beneath it if the rows beneath match
    By ilikeexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2012, 02:40 PM
  4. 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
  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

Tags for this Thread

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