Been a little while and my VBA is rusty.
I have data in sheet 1 column M and need to compare it to data in Sheet 2 column A.
Once a match is found I need the data for that row from sheet 1 column A to populate sheet Column B.
Sheet 1 Column M has 8500 rows and sheet 2 column A has 160.
I think the problem I am running into is the data in column M is MAC addresses.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Thanks for the help!
Jay
I have data in sheet 1 column M and need to compare it to data in Sheet 2 column A.
Once a match is found I need the data for that row from sheet 1 column A to populate sheet Column B.
Sheet 1 Column M has 8500 rows and sheet 2 column A has 160.
I think the problem I am running into is the data in column M is MAC addresses.
Sheet 1
Column A | Column M |
52AAAAAA-AAAAA | 00:00:00:00:00:08 |
52AAAAAA-AAAAB | 00:00:00:00:00:09 |
52AAAAAA-AAAAC | 00:00:00:00:00:11 |
52AAAAAA-AAAAD | 00:00:00:00:00:14 |
<tbody>
</tbody>
Sheet 2
Column A | Column B |
00:00:00:00:00:08 | Data from sheet 1 Column A |
00:00:00:00:00:07 | |
00:00:00:00:00:10 | |
00:00:00:00:00:09 | |
<tbody>
</tbody>
Thanks for the help!
Jay