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
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