Hello,
I have a workbook with two worksheet. Please help me out with anything Vlookup/Index match, VBA etc..
On sheet1 I have column A= part number, column G=price and column M=location. On sheet2 I have column A= part number, column D= date, column M=price and column K=location.
On sheet2 on Column A has same item number with multiple rows with different date on column D. is there a way that can be done in VBA/Vlookup anything that look up the oldest date and copy price on column G and location to sheet1?
Thank you very much. This would save me half day of work
sheet1
<tbody>
</tbody>
<tbody>
</tbody>
I have a workbook with two worksheet. Please help me out with anything Vlookup/Index match, VBA etc..
On sheet1 I have column A= part number, column G=price and column M=location. On sheet2 I have column A= part number, column D= date, column M=price and column K=location.
On sheet2 on Column A has same item number with multiple rows with different date on column D. is there a way that can be done in VBA/Vlookup anything that look up the oldest date and copy price on column G and location to sheet1?
Thank you very much. This would save me half day of work
sheet1
A | G | M | |||||||
Part number | Price | Location | |||||||
1 | G1APPLE | 8.00 | B13 | ||||||
2 | G2PEAR | 9.00 | b5 | ||||||
3 | G3ORANGE | ||||||||
4 | |||||||||
5 |
<tbody>
</tbody>
a | d | k | m | ||
part number | date | location | price | ||
1 | G1APPLE | 10/08/2019 | B12 | 5.00 | |
2 | G1APPLE | 10/01/2019 | B13 | 8.00 | |
3 | G2PEAR | 10/03/2019 | B5 | 9.00 | |
4 | G2PEAR | 12/05/2019 | B6 | 6.50 | |
5 |
<tbody>
</tbody>