Hi
I have vba code that will allow you to link to SAP tables and extract data where necessary.
This code is based upon parameters I created with my previous employer Schaeffler.
If you're interested, I'll happily help you to create the tool you need. The code was written in Access vba but the reference library's, etc should also work in Excel. If not, no charge.
Get in touch and we can run through the details.
Thanks
Darren