I have been tasked with a extracting some data from a spreadsheet not being that good i would like some help with VBA
all the data is on sheet 1 and there is duplicated through out.
the way it is layed out is where ever there is a part number there is a serial number in the right hand cell. What i want to do is use list of part numbers in Colmn A sheet 2 search in sheet 1 and Paste the found serial numbers next to the selected part numbers in sheet 2 if that maked sense.
Thanks
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
all the data is on sheet 1 and there is duplicated through out.
the way it is layed out is where ever there is a part number there is a serial number in the right hand cell. What i want to do is use list of part numbers in Colmn A sheet 2 search in sheet 1 and Paste the found serial numbers next to the selected part numbers in sheet 2 if that maked sense.
Thanks
Sheet 1
Part 1 | Serial | ||||
part2 | serial | ||||
Part3 | Serial | ||||
Part 5 | Serial | ||||
<tbody>
</tbody>
Sheet 2
Part 1 | Serial |
Part2 | |
Part 3 | |
Part 4 | |
Part 5 |
<tbody>
</tbody>