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...
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.
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.
- I have no idea how the master was created for the video; I doubt there was anything mysterious.
The real question is how YOUR data sets are created, how they're organized, whether they're designated as official Excel "Tables"... is it in any way possible for you to post either the actual workbook OR a mockup of the master and one or two of the subordinate sheets from which you want to extract data?