Please clarify you want to club all 7 sheets into one or wish to produce 7 output sheets as per Table Format (Presently covers USA1 only) . Some observations—SANTOS (S/B) and SANTOS are different (unless we hard code them same). Date formats for ETB and ETS are different in Table Format and USA1. I shall maintain as desired. Where to get STATUS. Service “USA STRING I” as mentioned for Column D to J, but Column L to R is blank. This implies MSC MICHAELA is not part of USA STRING I. You are covering “Port of Loading” but not “Port of Unloading” may be the same not needed by you. Evidently you need macro to do the job. This block has limited space to discuss. Please initiate dialog...
I am Mechanical Engineer, proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas.
About Myself
Good Day!. Let me introduce myself for building your confidence in me.
Worked at Sr. position with experience of marketing, Service, Production and IT
Excel Expert Group Member
Access Expert Group Member
Worked on Macro, VB, Pivot, User Form, Google Sheets
Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral,
Qualification- Mechanical Engineer
Available on Skype
Some Projects:
Developed complete ERP system for Marketing in DB4 (earlier to Access)
SAP implementation as Key Coordinator
Community Survey (Near 10 Million Data compilation) in Excel
Industrial Project Report in Excel
Multilingual Kazien Sheet in Excel with VB
Offer Pr