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 number, B is the description and C is the sprint number. I would like to create a master sheet that will group the data from the various worksheets based on the shared value in column c. For example, everything that has a value of 9 in column c across all of the worksheets would be grouped together. I’d also like each of them to link to their location, so if story 100 is scheduled for sprint 9 and is in the search UI feature worksheet, and story 101 is scheduled for sprint 9 and us in the email feature worksheet, they would be grouped together on the master and I would be able to see all three column entries for each. If I were to click on the search UI feature row, I would be taken to the Search feature worksheet. I would also like the master worksheet to update whenever any of the data on the other worksheets are updated. Is this possible in excel? This is a work document and I cannot attach anything. I am using a PC, windows 10 I believe.
5 Replies
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?
