+ Reply to Thread
Results 1 to 2 of 2

Insert cells below existing rows

Hybrid View

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    6

    Insert cells below existing rows

    I have several PO's, and I need to insert a table of content beneath each PO. (for example)

    xx00001 - SPIRAL PLATE COIL HEAT EXCHANGERS - abc company
    xx00001 - AIR COOLED HEAT EXCHANGERS - blue skies company
    xx00001 - STEAM JET EJECTORS - groundhog firm

    and insert....


    EQUIPMENT TAGS
    INDEX OF DOCUMENTS
    DIMENESIONAL DRAWINGS
    TEST REPORTS
    INSTALLATIONS MANUAL
    OPERATIONS MANUAL
    MAINTENANCE MANUAL
    SPARE PARTS
    DATASHEETS
    CALCULATIONS
    WIRING
    DEVIATIONS

    so it comes out like.....

    xx00001 - SPIRAL PLATE COIL HEAT EXCHANGERS - abc company
    EQUIPMENT TAGS
    INDEX OF DOCUMENTS
    DIMENESIONAL DRAWINGS
    TEST REPORTS
    INSTALLATIONS MANUAL
    OPERATIONS MANUAL
    MAINTENANCE MANUAL
    SPARE PARTS
    DATASHEETS
    CALCULATIONS
    WIRING
    DEVIATIONS
    xx00001 - AIR COOLED HEAT EXCHANGERS - blue skies company
    EQUIPMENT TAGS
    INDEX OF DOCUMENTS
    DIMENESIONAL DRAWINGS
    TEST REPORTS
    INSTALLATIONS MANUAL
    OPERATIONS MANUAL
    MAINTENANCE MANUAL
    SPARE PARTS
    DATASHEETS
    CALCULATIONS
    WIRING
    DEVIATIONS
    xx00001 - STEAM JET EJECTORS - groundhog firm
    EQUIPMENT TAGS
    INDEX OF DOCUMENTS
    DIMENESIONAL DRAWINGS
    TEST REPORTS
    INSTALLATIONS MANUAL
    OPERATIONS MANUAL
    MAINTENANCE MANUAL
    SPARE PARTS
    DATASHEETS
    CALCULATIONS
    WIRING
    DEVIATIONS



    Any ideas? Thanks for any assistance!!!

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Insert cells below existing rows

    On a separate part of the spreadsheet or another page list the insert values. FYI I used Range("G19:G30")

    Sub REFisher14()
    Dim i As Long
    For i = ActiveSheet.UsedRange.Rows.count To 2 Step -1
        If Range("A" & i).Value <> "" Then
        Range(Range("A" & i).Offset(1), Range("A" & i).Offset(12)).Insert xlDown
        Range(Range("A" & i).Offset(1), Range("A" & i).Offset(12)).Value = Range("G19:G30").Value
        End If
    Next i
    End Sub

+ 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. Insert rows between rows without replacing existing data.
    By m-steele@shaw.ca in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2012, 01:31 AM
  2. Insert new rows between existing cells with missing sequential dates
    By madball87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2011, 11:06 AM
  3. Insert rows between existing data
    By Tickla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2010, 03:30 AM
  4. Insert Rows between existing
    By redmalva in forum Excel General
    Replies: 1
    Last Post: 08-13-2009, 10:54 AM
  5. Insert 2 rows after every existing row
    By Elaine K in forum Excel General
    Replies: 1
    Last Post: 05-18-2009, 12:27 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