Just like the title states, I have multiple sheets that all contain tables with similar data that can all be connected via a unique identifier. What would be the best way of achieving this in excel?
The above image is an example of the main sheet where all of my gathered data will go. I want the yellow count columns to be named respective to what sheet the data was gathered from.
This second image represents the another sheet where the data is being gathered from. Here you can see the ID will correspond with the same person just with different count numbers.
Lastly, here is another sheet with more data but more or less the same structure. Again I have the ID and person name to correspond with. In this example, the total count is what I want to grab.
I'd appreciate any help I can get. Thanks
- Zooch
The above image is an example of the main sheet where all of my gathered data will go. I want the yellow count columns to be named respective to what sheet the data was gathered from.
This second image represents the another sheet where the data is being gathered from. Here you can see the ID will correspond with the same person just with different count numbers.
Lastly, here is another sheet with more data but more or less the same structure. Again I have the ID and person name to correspond with. In this example, the total count is what I want to grab.
I'd appreciate any help I can get. Thanks
- Zooch
