Share via

Single Excel range populate multiple tables based on columns?

Anonymous
2022-01-21T15:27:18+00:00

Is it possible to link a Powerpoint template back to a range (row) in an Excel worksheet and have that range fill individual tables based upon the column in the excel worksheet (ala this cell will always be column G in the range)?    THEN…. If that cell doesn’t contain data in the worksheet, have it not show in the Powerpoint document? Thx

Microsoft 365 and Office | Excel | For business | Other

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
    2022-01-21T17:27:02+00:00

    Hi DH_101,

    Thanks for posting in the community.

    After going through your description of the question, I have worked out a possible solution for your case. It can be time-consuming to follow the steps, but you may check if you would like to use this:

    1. Add Excel worksheet objects in PowerPoint as many as you need.
    2. Create a source Excel sheet which stores your desired range/row.
    3. Double click into each linked worksheet in PowerPoint, input the formula to reference cells in the source Excel sheet like the example below:

    After you have completed all the cells you need, you should be able to see all the cells are changed as corresponding cells changes in source Excel file.

    About "If that cell doesn’t contain data in the worksheet, have it not show in the Powerpoint document", the solution above should also meet your requirement.

    If it doesn't help, kindly share us with more info. We can work together to see if there are any other things we can do to make it work.

    Best Regards,

    Ryan

    Was this answer helpful?

    0 comments