Forum Discussion
ksouth2090
Jul 19, 2024Copper Contributor
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!! 🙂
- ksouth2090Copper Contributormathetes Can you help?
- mathetesSilver Contributor
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.
- ksouth2090Copper Contributor
Thank you!! mathetes Here's a copy of my workbook Master Retailers.xlsx