+ Reply to Thread
Results 1 to 8 of 8

Combine multiple sheets in Master

  1. 02-18-2019, 03:57 AM #1
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Combine multiple sheets in Master

    Hy! How can to combine more sheets in one master, without duplicates?
    Reply With QuoteRegister To Reply
  2. 02-19-2019, 02:38 AM #2
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: Combine multiple sheets in Master

    some help, please?
    Reply With QuoteRegister To Reply
  3. 02-19-2019, 02:41 AM #3
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Combine multiple sheets in Master

    You will need to attach a sample workbook with the sheets in question.

    Go Advanced -> Manage Attachments -> Upload
    Reply With QuoteRegister To Reply
  4. 02-19-2019, 03:09 AM #4
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: Combine multiple sheets in Master

    is copy just col A and col B. i want to copy all columns
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 02-19-2019, 04:07 AM #5
    banaanas
    banaanas is offline
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Combine multiple sheets in Master

    Put this into a module (not a worksheet)
    Please Login or Register  to view this content.
    Tuomas "Banaanas" Savonius
    Trying to give back now when I actually can do some VBA
    Reply With QuoteRegister To Reply
  6. 02-19-2019, 04:15 AM #6
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: Combine multiple sheets in Master

    if i run more time the module, in master is duplicated the data from sheets
    Reply With QuoteRegister To Reply
  7. 02-19-2019, 04:23 AM #7
    banaanas
    banaanas is offline
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Combine multiple sheets in Master

    Modified to cleat Master WS

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 02-19-2019, 05:37 AM #8
    Pirvu Vali
    Pirvu Vali is offline
    Forum Contributor
    Join Date
    08-21-2018
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    178

    Re: Combine multiple sheets in Master

    is working. thank you very much
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can you combine multiple excel sheets into one master excel?
    By anon7 in forum Excel General
    Replies: 2
    Last Post: 07-24-2017, 01:14 PM
  2. Combine columns data from multiple sheets to existing master sheet via cell value
    By 253.Asmo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2015, 12:13 PM
  3. Combine multiple sheets into master sheet, and include sheer name
    By FDibbins in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-18-2015, 10:32 PM
  4. Combine multiple sheets into one master doucument.
    By postrander in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2014, 07:54 PM
  5. Combine folder sheets to one master sheet
    By rchure in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2014, 01:11 AM
  6. Combine several workbooks containing data in multiple sheets into a master Workbook
    By sunrize9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2014, 09:10 PM
  7. Anyway to combine multiple sheets into master?
    By rbzurich in forum Excel General
    Replies: 1
    Last Post: 06-12-2007, 11:13 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1