Share via

How to auto populate list from different excel sheet based on date?

Anonymous
2024-03-15T20:23:56+00:00

Hello,

I am trying to auto populate a list from a different excel sheet based on the date. I have attached pictures of what I am trying to do.

My example is, I would like for the list from the "Social Media Schedule" excel sheet for March 15, 2024, to be auto populated on the "March" excel sheet under the social media schedule section.

But if the date changes to March 16, 2024, on the "March" spreadsheet I would like it to auto populate the list from the "Social Media Schedule" excel sheet for March 16, 2024.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-15T22:32:00+00:00

    Dear Julia_123456,

    I thank you for considering Microsoft Support.

    You can use Excel formulas like VLOOKUP or INDEX-MATCH to accomplish the desired functionality of having the list from the "Social Media Schedule" Excel sheet automatically populate based on the date chosen in the "March" sheet.

    Here is a detailed how-to for setting this up:

    Choose a cell on the "March" sheet where the date will be entered. The current date can be explicitly entered by users or automatically populated using the TODAY() method.

    For the purpose of retrieving the relevant information from the "Social Media Schedule" sheet, use this date value as the lookup criterion.

    Create formulas that dynamically extract data from the "Social Media Schedule" page by referencing the date cell. For example, you can use a formula similar to this one if the date is in cell A1 on the "March" sheet:

    'Social Media Schedule', =VLOOKUP(A1)! A:B, 2, UNTRUE

    This formula retrieves the corresponding information from column B after looking for the date in cell A1 of the "March" sheet within column A of the "Social Media Schedule" sheet.

    Make that the information in the "Social Media Schedule" sheet is arranged correctly, with listings of relevant dates in one column and dates in another.

    The formulas might need to be modified in accordance with the particular arrangement of your sheets and the data format.

    Do not hesitate to contact us for more help if you need it or run into any problems while going through this process. We are available to assist you!

    Warm regards, Saurabh Mishra Team Microsoft Support

    0 comments