Results 1 to 10 of 10

Help with autopopulating worksheets with data from a main sheet (in same workbook)

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2017
    Location
    Glasgow, Scotland
    MS-Off Ver
    365
    Posts
    6

    Help with autopopulating worksheets with data from a main sheet (in same workbook)

    I know his question has been asked before (many times), but I just can't seem to find the right formula/combination of formula to do what I need. I know tat I'm missing something, probably really simple, but for the life of me I can't figure it out.

    I am trying to autopopulate worksheets with data contained in the first worksheet. Basically it's an annual calendar of meetings, all 12 months showing on sheet 2. I will then produce monthly sheets with further information (only pulling some information from the first sheet.

    Whilst I've managed to get a straightforward formula to autopopulate a single entry, I can't get it to find the correct information to autopopulate the subsequent lines within that month!

    I've attached my file for reference.

    Many thanks in advance for any help!

    Lynne
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transfering data from one main sheet to multiple worksheets via date and status
    By SBlack6 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-17-2017, 12:40 PM
  2. Autopopulating multiple sheets in a workbook from one master sheet
    By aheffron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-07-2017, 07:15 PM
  3. Replies: 2
    Last Post: 10-01-2014, 04:18 PM
  4. Pulling data from a main sheet to subsequent sheets in a workbook
    By mary012277 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2014, 03:10 PM
  5. [SOLVED] Formula to place data from mulitple worksheets into 1 main sheet
    By lindafinlay in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-19-2013, 03:07 AM
  6. Linking worksheets through drop down menu's and autopopulating data
    By Tragicallyhip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2010, 11:14 AM
  7. Create copy of multiple worksheets and automatically fill in data from a main sheet
    By NMChemEng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2008, 05:28 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