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.
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.