Hello,
I managed 400 plus 40 foot shipping containers per year and worked with MSC and other ocean freight carriers significantly. I just have a couple questions.
1) Does your company allow automated plug-ins for excel?
2) MSC has RSS feeds that updates the current status changes on your shipments. (i.e., has it cleared customs, is it held up at customs, is it ready for pickup, etc) These updates can either be sent to you via RSS feeds in Outlook or you can hit refresh on your spread sheet and get the RSS update feed per BOL/Container number in excel.
To be clear, I am guessing you have a spreadsheet tracking all of your shipments. You track this by either the BOL number or container number. You want a solution that allows you to refresh your spreadsheet and auto populates the current status on all your containers?
This all depends on whether or not you are the seller/buyer and what the incoterms are. Are you the ones paying the ocean freight? This is the biggest obstacle for your question. The seller doesn't necessarily have to put you down authorizing reading access on MSC's website which I think the issue lies.
Anyway, if you are interested and can answer these questions, I believe I can help you.
thanks,
-Christian