I have extensive experience in developing MSExcel macros. In the last company I worked for, we automated the tedious copy/past process (text to excel, excel to text, from a database to excel), merge data from several worksheets to one worksheet, automatically prepare pivot table and etc. We even developed a queuing system using MSExcel as front end and MSAccess as database.
Now on your project, I need to know how to connect to the SAP table you are referring to. Or you can send me the connection string, table layout, screenshot of the table and some sample data.