+ Reply to Thread
Results 1 to 1 of 1

VBA Help!! Auto populate data to master from two other sheets in workbook

  1. #1
    Registered User
    Join Date
    08-24-2016
    Location
    Sacramento, California
    MS-Off Ver
    2010
    Posts
    8

    VBA Help!! Auto populate data to master from two other sheets in workbook

    Hello Experts:

    I am new to VBA and can use some expertise/advice. I am working in Excel 2010 and trying to find a code that auto populates data to a "Master" sheet when entered or deleted throughout entire worksheets.

    My workbook has Three sheets "Master" "Tracker" and "Archive". The "Tracker" and "Archive" sheets have columns A:U first row using headers.
    My "Master" sheets has newly added columns making range "A:Z"

    I researched other threads but cannot find a code that works with my spreadsheet.

    I believe its due to the newly added columns in my "Master" sheet. I added Column A to use as a number sequence 1,2,3,4,5 starting from A2. I added columns G:J extracting date from Received date from Column B on my "Master" sheet to run Pivots and reports.

    Thank you in advance. I also attached a copy of my spreadsheet as a reference.

    Below is a code I attached to my "Master" sheet.

    Private Sub Worksheet_Activate()
    Dim Sheet As Worksheet
    For Each Sheet In Me.Parent.Sheets
    If Sheet.Name <> Me.Name Then
    If Sheet.Cells(Rows.Count, 1).End(xlUp).Row <> 1 Then
    Sheet.Range(Sheet.Cells(2, 1), Sheet.Cells(Sheet.Cells(Rows.Count, 1).End(xlUp).Row, 21)).Copy Destination:=Me.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)

    End If
    Else
    Me.Range(Cells(2, 1), Cells(Rows.Count, 21)).Clear
    End If
    Next Sheet
    End Sub
    Attached Files Attached Files
    Last edited by Simple_man916; 08-24-2016 at 01:27 PM.

+ 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. Auto-populate data to a master worksheet from other sheets in a shared workbook
    By JennyJAL in forum Excel Programming / VBA / Macros
    Replies: 45
    Last Post: 08-20-2021, 12:08 AM
  2. [SOLVED] Auto-Populate Data to Master Sheet from Other Sheets in Workbook
    By datutt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2015, 05:36 PM
  3. [SOLVED] Auto-populate and sort data to a master worksheet from other sheets in a shared workbook
    By Gemma_g1985 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2014, 10:47 PM
  4. Auto-Populate Data From Master List to Separate Sheets When Two Criteria's Are Met
    By centibttrfly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-09-2014, 11:18 AM
  5. Replies: 3
    Last Post: 09-07-2012, 06:29 PM
  6. Auto Populate Master Sheet with multiple sheets data
    By haley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2009, 04:29 AM
  7. how to auto populate data from multiple sheets to a master
    By Fosachy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2009, 06:15 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