+ Reply to Thread
Results 1 to 18 of 18

Insert multiple rows each specific number of rows

  1. #1
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Insert multiple rows each specific number of rows

    Greetings to all
    I have data in sheet1.range("A8:S" & Last row)
    I need simply an effective way to transfer data from sheet1 to sheet2
    The transfer process would start in A8
    each 20 rows would be transferred then left the next 7 rows
    Blue cells as they are ... note that Blue cells in original file would contain formulas
    the same with the rest of data
    I have attached the expected results
    If possible I need to avoid loops as original data is too large
    Thanks advanced for help
    Last edited by salmasaied; 10-14-2016 at 09:22 AM.

  2. #2
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    Please Is it possible to assist me in this issue

  3. #3
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    Please Is it possible to assist me in this issue

  4. #4
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Insert multiple rows each specific number of rows

    Try this:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy
    Thank you very much to reply and thank your patience
    Up the number of data to more than 40,000 Statement
    I have tested the code sender on the number of data but it is very slow
    I do not need to insert a new worksheet
    while I want to copy data from sheet 1 to sheet 2
    Please I want your permission after the fastest way for the task
    I have this code added in the attached
    But he is very, very slow on the same number of data
    I hope that the idea is clear
    Thank you again for your attention
    Attached Files Attached Files
    Last edited by salmasaied; 10-16-2016 at 12:15 PM.

  6. #6
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Insert multiple rows each specific number of rows

    Try this:

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy .... welcome
    Thank you very much for your attention and your efforts on the distinctive
    Please add data to a larger number of and note result
    I've added in the attached code using arrays
    He works in an excellent manner
    but in absence of a merged cells in the column headers in a sheet 1
    Please note yellow cells in the sheet 2 with the activation code
    You will notice that the code takes a copy of the the row 6 and 7
    NB ... on the heads of the merged cells are important columns in the workbook
    Please see the attached ... fully in finding a solution to this issue
    Thank you very much for the help
    Last edited by salmasaied; 10-17-2016 at 01:40 PM.

  8. #8
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Insert multiple rows each specific number of rows

    Amended your code:

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy .... welcome
    I have made these modifications to no avail
    Note me the number of the first group of 18 row only
    So what is the way to resolve this problem
    We will try together to reach a solution to the importance of having merged cells
    Thank you dear friend

  10. #10
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy .... welcome
    Modified in this way
    Thank you very much for the help


    Please Login or Register  to view this content.
    Last edited by salmasaied; 10-20-2016 at 02:46 PM.

  11. #11
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy .... welcome
    Is it possible to copy formats in the same sheet formats Source
    Thank you very much for the help
    Last edited by salmasaied; 10-21-2016 at 07:52 PM.

  12. #12
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Insert multiple rows each specific number of rows

    Are you want this?

    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy .... welcome
    So shall it be of Excellence
    The words of thanked small in front of this great effort
    NB... that only one after permission
    What if a data finished at No. 117 or 6014 for example
    You will notice this debug line message

    Please Login or Register  to view this content.

    Is it possible to make this modification
    Other than that, the code works more than excellent
    Thank you my dear friend for this wonderful help
    I wish you happiness in your life and further the advancement and progress
    Last edited by salmasaied; 10-24-2016 at 02:43 AM.

  14. #14
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy .... welcome
    Hope to complete this topic after this permission
    Thank you very much for the help

  15. #15
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    Please Is it possible to assist me in this issue

  16. #16
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    Please Is it possible to assist me in this issue

  17. #17
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Insert multiple rows each specific number of rows

    Debuged:

    Please Login or Register  to view this content.
    Last edited by ikboy; 10-23-2016 at 11:52 PM.

  18. #18
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Insert multiple rows each specific number of rows

    My dear sir, ikboy
    I'm in a beautiful dream
    This wonderful solution of the more fascinating personality
    Thank you my dear friend
    Thank you for your patience with me and the beautiful your spirit

+ 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] Insert multiple rows each specific number of rows
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 05-21-2016, 10:36 AM
  2. [SOLVED] Macro to insert specific number of rows, populate rows with data above except date
    By Melissa Camp in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-08-2015, 03:59 PM
  3. Replies: 0
    Last Post: 03-06-2013, 05:44 PM
  4. [SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows
    By tstell1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 04:15 PM
  5. Need Macro to insert a Specific number of Rows (in Filtered list)
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2012, 08:05 PM
  6. Copy and insert rows with contents and format based on specific number
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-13-2012, 03:38 AM
  7. Insert multiple rows in specific sections of sheet?
    By Marylander in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2007, 01:12 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