Forum Discussion
Creating a master sheet that groups data across worksheets based on a shared value in common column
I’m creating an excel doc to map out and organize features for a project. I have the different features broken down into separate worksheets. N each worksheet there are three columns. A is the story n...
Unless I'm mistaken the FILTER function would work (IF, that is, you have the most recent version of Excel on your Windows machine). I use it to access external files, in a process quite analogous to what you're describing, as it also allows you to specify the criteria to be met for the rows to be "imported."
Here's a link to a helpful video introducing the FILTER function just last year. https://www.youtube.com/watch?v=9I9DtFOVPIg
- Hi Mathetes,
Thanks for the response. I should have been clearer about what I was trying to do. Everything is actually in the same excel doc, the different features are in different tabs.- That makes it even easier. The FILTER function will work within workbooks as well. Have you watched the video?
- I have watched the video. It does appear to be what I need, although a bit over my head. If you’re able to help, how was the master sheet created in the demo in the video and how would I be able to get that to work to pull in data from multiple tabs? Also, I don’t need the master to complete any calculations. I just need the rows to pull into the master and allow sorting. More rows will be added to the various tabs on a daily or weekly basis.
