Forum Discussion

ksouth2090's avatar
ksouth2090
Copper Contributor
Jul 19, 2024

Excel Formula Help! Automate data from tabs to master tab

Hello! I am having trouble figuring out how to automate data between tabs. I have a Master list and then separate sheets with each category. I would like to be able to input data into the category sheet and it automatically populate into my master sheet. Is this possible? Any help would be greatly appreciated!! 🙂

 

 

    • mathetes's avatar
      mathetes
      Silver Contributor

      ksouth2090 

      Can you help?

       

      Not from an image.

       

      The FILTER function could work in the other direction quite easily. Have a master database that contains all the details, then use FILTER to populate various sub-categories. Beyond that, you may be talking Power Query, which I've never used.

       

      But you'd be able to get more responses from others if you posted not an image, but rather a copy  (or mockup) of the actual workbook. If you can't post it here, then use OneDrive or GoogleDrive and paste a link here that grants access.

Resources