+ Reply to Thread
Results 1 to 4 of 4

Automatically copy data entered on four sheets into one Master sheet

  1. #1
    Registered User
    Join Date
    11-11-2020
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    4

    Automatically copy data entered on four sheets into one Master sheet

    Hi

    I have an excel document which is essentially one large action tracker.

    Each 'tab' is as follows and represents the Master sheet (which should automatically have all data entered from the other sheets columns A-M inclusive) and then each other sheet is for each individual meeting.

    I have designed it so columns A-M in each sheet are the same headers and will contain the same information - anything individual to a meeting which will not be on the master sheet is column M onwards.

    The idea is that people can update their own actions in the individual sheets, and these will automatically transfer to the Master sheet for columns A-M only, from which I can collate data and see a master overview of everything.

    My question is, how on earth do I get the data from each of the sheets to the master?!

    Tab 1: "Master"
    Tab 2: "Implementation"
    Tab 3: "Validations"
    Tab 4: "Governance"
    Tab 5: "Line 2 and 3"
    Tab 6: "Subcos"

    I am Ok with pasting code into Visual Basic if required.

    any help hugely appreciated!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    27,042

    Re: Automatically copy data entered on four sheets into one Master sheet

    I suppose the first question is "Why have 5 sheets? Would it not be simpler to have everything on a single sheet, with individual users applying a filter to let them adjust/amend the bit that is relevant to them?
    Glenn



  3. #3
    Registered User
    Join Date
    11-11-2020
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    4

    Re: Automatically copy data entered on four sheets into one Master sheet

    Hi Glenn, thanks for your reply.

    Unfortunately, each sheet is quite different and has tens of other columns that would not be relevant to the master sheet.

    The idea of the master sheet would be to collate all of the key indicators that each meeting has in common, and the rest which are not relevant to all meetings are after column M and can still be viewed if required - The master sheet would be a collation of the common data fields only.

    Hope that makes sense, but open to any simpler ways of doing things!!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,163

    Re: Automatically copy data entered on four sheets into one Master sheet

    Perhaps the following linked article describing how to join/merge tables using Power Query may be useful.
    https://www.ablebits.com/office-addi...th-Power-Query
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Automatically create a copy of Master sheet when data entered into specific rows
    By itsawayoflife in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2018, 02:39 AM
  2. master sheet that feeds data into sheets in workbook automatically
    By excelppchelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2018, 05:17 PM
  3. Automatically Copy Data From Multiple Sheets To A Master
    By oliverhj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-16-2016, 10:53 AM
  4. Copy and Paste data automatically from master sheet to other sheets
    By wschleis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 04:29 PM
  5. [SOLVED] Automatically Copy Data from Multiple Sheets to a Master Sheet
    By Ryan_Brandt in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-10-2014, 06:45 AM
  6. Replies: 2
    Last Post: 07-17-2014, 09:46 PM
  7. Replies: 6
    Last Post: 11-08-2013, 11:59 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