Understand you want to transfer data in the file “May 2016 Member List” in the format “Nextra Foldfolio for OP” and then save as csv file. There are extra fields in “Nextra …” for Customer, Bill To and Ship To. Since there is no such differentiation in “May..” the data can be considered same for three category.
An macro can do these job repeatedly. You can use different files with different name but with same structure. The file now can be uploaded as per normal procedure.
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
Proficient in Google Sheet
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 Preparation in Access
Project Planner in Excel
Very Large Database Analysis
Completed few Contests at Freelancer
For Details of my Work
1. Please see my profile
2. Please see Services offered by me.
If you initiate..