+ Reply to Thread
Results 1 to 10 of 10

Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

  1. #1
    Registered User
    Join Date
    02-10-2024
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    5

    Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    I have a Google Sheet with three tabs:
    • Members
    • Schedule
    • Agenda

    We use the schedule sheet to create meeting role assignments (data validated based on members sheet). We want to then use a pull down to choose an applicable date (see C1 in the Agenda sheet) and then have that populate the agenda sheet for the meeting specified by that chosen meeting date.

    Here is a copy of the spreadsheet - Copy of Meeting and Agenda Planner.xlsx

    Trying to find the right function in the agenda list so that the right meeting roles and meeting agenda appear in Column C (Agenda Sheet) based the date selected.

    In the future, new meetings will be scheduled creating new columns to the right of those already in the Schedule tab

    Trying to find the best way to do this but struggling.

    So grateful for any guru help
    Last edited by VMatt314; 02-10-2024 at 07:36 PM. Reason: Adding sample spreadsheet

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2403 (Windows 11 22H2 64-bit)
    Posts
    78,155

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    Moved to the GoogleSheets section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,052

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    This could work for you (in C3 and dragged down) if you gave the same role names on both sheets:

    Please Login or Register  to view this content.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,297

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    You said you were working with Google Sheets, but you have attached an Excel workbook. Can you please clarify your platform so we can give you an appropriate solution?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  5. #5
    Registered User
    Join Date
    02-10-2024
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    5

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    Thanks, Jeff. I am working on Google Sheets but being new to Excel Forum I was not able to paste a link to the google Sheet so had to save as an Excel file and attach it. Sorry for the confusion. Appreciate any thoughts you may have for this issue.

  6. #6
    Registered User
    Join Date
    02-10-2024
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    5

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    Thanks, Ali. I am trying to find that new section - which I agree is a better thread under which to have posted. Can you help? I am a newbie and need a little hand-holding, I'm afraid

    Thanks again!

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,297

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    Quote Originally Posted by VMatt314 View Post
    being new to Excel Forum I was not able to paste a link to the google Sheet
    The prohibition is against posting a clickable link. If you remove the "https://" part it should accept it, then people have to copy and paste it into their browser address bar. The reason we prohibit it for new users is that we get a lot of hit-and-run spam with links to commercial or illegal sites, and it's one way to block that kind of spam.

  8. #8
    Registered User
    Join Date
    02-10-2024
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    5

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    Thanks, that helps. Got a fast and perfect response from janmorris

  9. #9
    Registered User
    Join Date
    02-10-2024
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    5

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    Thanks janmorris. That worked PERFECTLY!!! So grateful.

  10. #10
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,297

    Re: Populating a Meeting Agenda Sheet From Weekly Schedule Sheet

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.

+ 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] Creating a Daily View from a weekly schedule - move data from one sheet to another by date
    By vg05 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2021, 11:09 AM
  2. Populating a weekly schedule based on criterias with formula
    By Rebelexcel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-16-2020, 12:19 PM
  3. Weekly Meeting Agenda Workbook
    By ara.darakjian in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-06-2020, 12:27 PM
  4. Replies: 0
    Last Post: 03-11-2020, 01:45 PM
  5. meeting agenda, using various filters
    By btx in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-14-2016, 05:09 AM
  6. VBA needed to copy only rows from sheet 3 meeting criterium YES and paste in sheet 4
    By Robert1311 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2014, 10:33 AM
  7. Replies: 0
    Last Post: 06-19-2012, 11:36 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