Hi all,

I have an excel workbook, and in cell A1 there is a material reference. I would like to have an excel macro that looks for the parts that are in stock in SAP transaction MBBE from the reference shown in the cell A1 and then export from SAP the number of parts in stock to cell A2 in Excel. Which vba excel code could achieve this automatically? Is it even possible?

In case could not be possible... Can I download the stock from MBBE of all the part numbers in SAP and paste it to a workbook sheet called "Sheet 2"? How could be the code please?

Thank you all in advance for your help