+ Reply to Thread
Results 1 to 10 of 10

Copy , Insert rows and Paste data from two sheets to third sheet

  1. #1
    Registered User
    Join Date
    03-30-2020
    Location
    India
    MS-Off Ver
    MS Office 10
    Posts
    3

    Copy , Insert rows and Paste data from two sheets to third sheet

    I have data in two sheets one sheet having customer and another having material data. In both sheets, unique column in Base Cust. In customer sheet, each Base cust has 1 or more different customers and material sheet has same like each Base cust has different materials. I want to consolidate both sheets data in new sheet.

    For example -

    Sheet1 has following data

    Base cust customer

    00301 112501
    00301 112502
    00302 112503
    00302 112504
    Sheet 2 has following data

    Base Cust Material

    00301 M12113501
    00301 M12113502
    00302 M12113501
    00302 M12113502
    In New sheet data should looks like

    Base Cust Cust Material

    00301 112501 M12113501
    00301 112501 M12113502
    00301 112502 M12113501
    00301 112502 M12113502
    00302 112503 M12113501
    00302 112503 M12113502
    00302 112504 M12113501
    00302 112504 M12113502
    I need your help if you can provide me VBA codes to prepare this kind of above data.

    Thanks.

    Narendra

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    There is no headers???
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    See next code
    If there is alot of rows it takes time ...!
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-30-2020
    Location
    India
    MS-Off Ver
    MS Office 10
    Posts
    3

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    Hello

    Thanks for providing codes. However, all required data is not inserting in required sequence new sheet.

    Can you please recheck.

    Thanks

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,722

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    Another Option...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

  6. #6
    Registered User
    Join Date
    03-30-2020
    Location
    India
    MS-Off Ver
    MS Office 10
    Posts
    3

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    Hello

    You are simply great. It helped me a lot as I had to prepare data for 60K+ rows.

    Thank you so much.

    Regards

    Narendra

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,722

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    I had to prepare data for 60K+ rows.
    Might require faster code for that...Perhaps uploading a sample file depicting actual size of rows...

  8. #8
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    However, all required data is not inserting in required sequence new sheet.
    It is like you shown it ...!
    It looks like Sintek's code is not giving the same amount of rows in final result, is there filter to apply; is final result text or numbers ??
    You seem satisfied with last code, for adjustments please attach an Excel sample.

  9. #9
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,722

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    It looks like Sintek's code is not giving the same amount of rows in final result
    Did I miss something?
    Untitled-1.gif

  10. #10
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Copy , Insert rows and Paste data from two sheets to third sheet

    There is certainly some misunderstanding concerning data: See file attached
    But OP is happy so let's see for another pleasure ..
    Attached Files Attached Files

+ 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] How to Copy Rows from two Sheets and Paste it in 3rd Sheet One Bellow
    By MoldyBread in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2018, 10:45 AM
  2. Copy rows from multiple sheets paste to new sheet
    By cindywylie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2017, 04:06 PM
  3. Copy cells with data - paste (insert rows) to next sheet.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2016, 01:28 PM
  4. [SOLVED] insert sheets 2 & 3 and copy & paste data from the first sheet
    By RobinPrice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 12:24 AM
  5. [SOLVED] Copy from different sheets- data based on selection and paste rows in new sheet
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 03:30 AM
  6. [SOLVED] Copy, paste and insert new rows into new sheets
    By nanas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2012, 10:35 PM
  7. Copy paste data, insert rows, insert data and change . to -
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2010, 01:44 AM

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