+ Reply to Thread
Results 1 to 4 of 4

VBA codes to insert the rows and copy the first entire row text and insert sheet

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2010
    Posts
    309

    VBA codes to insert the rows and copy the first entire row text and insert sheet

    I have a file around 800000 rows.

    I want to insert the only one rows when a code series end and copy the first row text in all the rows before starting the code series.

    Please refer the attach file for more clarifications.

    For an example,In this file,
    1-Insert the one rows after cell no.I741 and copy the rows no.C5 in all the rows start before code series.
    2-when double click on any unique code then insert the worksheet with code name and copy entire code datas.e.g.refer the sheet 'Display result' and double click on cell no.I744 .Now,the sheet name should appear as 'FNSBDRKSC' and copy entire rows and column having the code 'FNSBDRKSC' on that sheet.It should start from cell no.B5.

    Is it possible thru VBA codes working?
    Attached Files Attached Files
    Last edited by PRADEEPB270; 10-26-2013 at 02:34 AM.
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,094

    Re: VBA codes to insert the rows and copy the first entire row text and insert sheet

    Hi, PRADEEPB270,

    in a standard module
    Please Login or Register  to view this content.
    Behind the worksheet BOM:
    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
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2010
    Posts
    309

    Re: VBA codes to insert the rows and copy the first entire row text and insert sheet

    Many-2 thanks for the awesome working provide to me.It will reduce my lot of time consume. very glad to find the result.

    Regards

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,094

    Re: VBA codes to insert the rows and copy the first entire row text and insert sheet

    Hi, PRADEEPB270,

    thanks for the feedback. Do you mind marking this thread Solved via Thread Tools over the first post?

    Ciao,
    Holger

+ 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. Replies: 4
    Last Post: 08-03-2013, 04:08 AM
  2. [SOLVED] Copy entire row in insert in the middle of a table.
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-21-2013, 10:59 AM
  3. Copy and Insert Entire Row into another sheet
    By shivark79 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2012, 02:41 PM
  4. Insert new rows and copy text macro help
    By b50 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2011, 03:17 PM
  5. [SOLVED] insert a new row between exsisting rows on entire worksheet
    By Andy in forum Excel General
    Replies: 5
    Last Post: 05-03-2006, 01:40 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