I need to update costs prices in a workbook from a data export from Sage Accounts.
I can save from Sage to an Excel workbook in the following format:-
A B
1 P/No Price
2 SL6002 2.05
3 RT1005 1.30
4 GR2005 3.70

My Master Workbook has several columns including P/No and Price
I need to update the Price in this master Workbook from the saved Sage export data.
The common data in both workbooks is the P/no.
I need to have both workbooks open and then push a macro button to
automaticaly update the cost prices in the Master Workbook.
Can someone let me have the code for doing this?
Thanks Ted