Forum Discussion

brianlv's avatar
brianlv
Copper Contributor
Dec 12, 2023

Excel Tables - Table Data based on Another Table

I am sure its easier than I think, but I can't figure out how.    I have a main table (table 1) with data for multiple events. Some of those events we need to get permits for (say all the ones that...
Excel
Excel for web
Formulas and Functions
office 365
mathetes's avatar
mathetes
Silver Contributor

brianlv 

 

You would help us help you by posting copies of the actual workbook(s) on OneDrive or GoogleDrive. Images are helpful, but nowhere near as much as the actual thing.

 

Just be sure to delete or anonymize any confidential or proprietary information first. Then paste a link here that grants access.

brianlv's avatar
brianlv
Copper Contributor
Dec 14, 2023

mathetes definitely understand. here is an example, if something doesnt make sense, let me know and i will try to explain it better.

 

Example  


thanks

  • mathetes's avatar
    mathetes
    Silver Contributor
    Dec 14, 2023

    brianlv 

     

    That link takes me to google, but it doesn't grant access. You need to create a different kind of link.

     

    • brianlv's avatar
      brianlv
      Copper Contributor
      Dec 14, 2023
      i updated the access levels for the link. should be able to open it now. i didnt realize it wouldnt allow access if i provided the direct link.

      thanks,
      • mathetes's avatar
        mathetes
        Silver Contributor
        Dec 14, 2023

        brianlv 

         

        Mixing Input and Output on single sheets, especially when they're essentially the same kinds of lists, and unavoidably when you're expecting (miraculously) that each will update the other, just makes for trouble.  

         

        I would strongly suggest that you make Input (or "RawData") a sheet of its own, and do ALL input on that sheet. Then have either:

        • a single "dynamic" output sheet, where you can select any given city from the rawData sheet, and get a display of all the data for that city, or
        • individual sheets for each city displaying the data for that city.

        See the attached example.

Resources