Hi
I have two spreadsheets one I upload to the cloud for the sales team to use. The other is an ODBE spreadsheet from sage.
I am hoping that the ODBE spreadsheet will update automatically from sage.

Is there a formula I can use to get the relevant data from the OBDE to the upload sheet. Such as stock quantity and prices

Both files are indexed on the product code but the ODBE file is likely not be constant as I add and remove codes.
Any help would be appreciated
David