Results 1 to 9 of 9

Auto-Populate Monthly tabs from based upon data entered on aggregate data sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2019
    Location
    Texas, USA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Auto-Populate Monthly tabs from based upon data entered on aggregate data sheet

    Hello All,
    I'm hoping this is the correct forum for my query. I am working on a project where I need to be able to enter my data in one location on the "ALL DATA" sheet; then have the data entered in the sheet populate into the corresponding monthly sheets.

    For example, patients born in January ("MONTH" column D) will have their row data copied to the sheet called, "January 2019", and so on, for each patient by month. I've attached an example spreadsheet below.

    Does anyone have experience with this type of macro, or formula? (I'm a novice, so please take pity on my soul!)
    Attached Files Attached Files
    Last edited by Ndavids1; 05-06-2019 at 01:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Populate A Cell Based On Data Entered into Two Possible Cells.
    By Angry Robot in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-21-2017, 02:11 AM
  2. Auto populate based on matched data from other sheet
    By ikhan99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2016, 10:49 AM
  3. [SOLVED] VBA to Auto Populate the “AutoPopulate” sheet as data is being entered in EnterData sheet
    By bjnockle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-13-2014, 09:10 AM
  4. Auto Populate Two Columns Based On Data Entered Into Another Column
    By aleenah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 08:37 PM
  5. [SOLVED] Auto populate fields based on data in a drop down box from a second sheet
    By Grazzio in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2012, 10:34 AM
  6. Auto –populate data from one sheet to another based on month
    By Roadrunner17 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2012, 05:44 PM
  7. Auto-populate cells based on data from another sheet
    By tmartin1313 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-16-2011, 12:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1