mrsbrannon
Board Regular
- Joined
- Mar 7, 2018
- Messages
- 61
Hello all,
I have two tables of data that is the "same" but being pulled from two difference sources. I need a way to combine this data and check for differences. The data is currently all in one workbook (but different sheets) and I would like to keep it that way. One set of data is manually entered and the other is exported from a report. Below is an example of the two sheets. The column headers do not match as the report headers are automated. If I HAVE to change the manual data (headers) to reflect the automated report, I can, but prefer not to.
<tbody>
</tbody> Sheet 1
<tbody>
</tbody>Sheet 2
<tbody>
</tbody>Desired Result
I feel like the answer is fairly simple, but I cannot put my finger on it. I've tried doing pivot tables with multiple consolidated data ranges, but that doesn't produce what I'm looking for. Any assistance is greatly appreciated.
Thanks.
I have two tables of data that is the "same" but being pulled from two difference sources. I need a way to combine this data and check for differences. The data is currently all in one workbook (but different sheets) and I would like to keep it that way. One set of data is manually entered and the other is exported from a report. Below is an example of the two sheets. The column headers do not match as the report headers are automated. If I HAVE to change the manual data (headers) to reflect the automated report, I can, but prefer not to.
Employee Name | Hours Worked |
Smith, John | 5 |
Brown, James | 10 |
<tbody>
</tbody>
User Name | Hours Entered |
Smith, John | 5 |
Brown, James | 11 |
<tbody>
</tbody>
Employee Name | Hours Worked | Hours Entered |
Smith, John | 5 | 5 |
Brown, James | 10 | 11 |
<tbody>
</tbody>
I feel like the answer is fairly simple, but I cannot put my finger on it. I've tried doing pivot tables with multiple consolidated data ranges, but that doesn't produce what I'm looking for. Any assistance is greatly appreciated.
Thanks.