+ Reply to Thread
Results 1 to 2 of 2

Copy specific data from multiple sheets to one

  1. #1
    Registered User
    Join Date
    08-08-2017
    Location
    Skanderborg, Denmark
    MS-Off Ver
    365
    Posts
    7

    Copy specific data from multiple sheets to one

    Hi,

    I have a number of sheets for different clients.

    Client1
    Client2
    Client3

    The different client sheets contains different data, but columns A through L have the same headers in all sheets.

    I would like to copy data from Client1, Client2 and Client3 columns A through L, and paste all of the data into MASTER sheet (Master sheet contains the same headers in column A trough L) without overwriting any data or removing dublicates

    See attached example. Rows 3 & 4 in sheets Client1, Client2 & Client3 should amount to data in rows 3 to 8 in the MASTER sheet.

    Thank you for your help.

    /Andreas
    Attached Files Attached Files
    Last edited by RMKamper; 05-20-2019 at 09:35 AM.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    1,832

    Re: Copy specific data from multiple sheets to one

    Please Login or Register  to view this content.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, click the 'Go Advanced' button, Then click 'Manage Attachements' and follow the menu.
    Thinking I am smart and knowing I am smart are two entirely different levels of schizophrenia.

+ 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] Add new row at row 10 in multiple sheets and copy and paste from specific cells
    By MICowboy13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2014, 03:39 PM
  2. [SOLVED] VBA Paste Specific Data To Specific Rows On Multiple Sheets
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-13-2014, 09:35 AM
  3. [SOLVED] Copy Multiple Sheets to New WorkBook but not specific sheet
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2014, 09:36 AM
  4. Need to copy ranges from multiple sheets then paste to sheet under specific headers
    By the duke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2013, 12:17 AM
  5. macro to copy specific cells from multiple sheets
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-24-2012, 09:34 AM
  6. Copy specific cell from multiple sheets to summary - excluding some sheets
    By kabammi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2012, 09:27 AM
  7. Replies: 3
    Last Post: 11-18-2008, 09:22 PM

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