Auto convert specific spreadsheet to a table format

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

Hello, Hope you are doing good, I read the job description and checked the spreadsheets. It’s my kind of work. I can complete the project timely and within your budget. I have an advanced knowledge of Internet research, Web Scrapping, Data Mining, MS Excel, Powerpoint and Word. Kindly share the details and I assure you of high-quality work. Looking forward to working with you. Thank You. Chopra C, India.

----------------------------------------Pro VB Developer! Best Result in Time!-----------------------------------------

Hi Im an expert in .Net technologies and SQL server I think what u need is a different aproach, since your data has been grown Meyba a Sql Server with an intranet front is a better solution for you regards Carlos

I have seen all the spreadsheets. I can do all that is required. Using the data in the 7 workbooks, I will create a single spreadsheet as per the sample provided. If this task is of the repetitive nature, then I can create a macro to automate the process

Hello, I have seen two of your files and I guess I got what do you want to do here. I can do this for you, I'm excel developer and I can organise all this data as you need. I will work carefully and with accuracy for you in this oportunity to get this well done and delivers you a table format you desired with all your ships info like (ETA, ETC, ETB). I'm familiar with this subject since I'm oil scheduler and I works scheduling oilpipes and a SPM. I hope hear from you soon to work together! Regards, Luis Romero

Hello, I can help you with the template. I will create a macro that with a click of a button, all files in the folder will be opened automatically and data copied into a structured format in one file. If you are interested please open a chat with me. Kind regards, Sorin