I need a Excel macro solution to build cost sheet worksheets from a Template, with data from incoming excel files (preformatted) which the user selects .
Programmer must be able to create documented code which will run on Excel 2010 to Excel 2016. Programmer must not make hard coded links the files (with the exception of the template file). Unicorn solutions which only run correctly in the developers mind, and computer will not be paid final milestone. Final milestone payment after accepted working solution which satisfies the spec.
Program needed to read a few incoming (consistently formatted) files to populate and create formatted Excel output ‘cost sheet’ files. These ‘cost sheets’ should be worksheets in an excel workbook, with the ‘style name’ as the work sheet header. Data should be ‘mapped’ and copied into the cost template using the header fields as the descriptors.
There should be a macro routine/subroutine for the user to select the incoming files for generating the cost worksheets. One for the linesheet information, one for the BOM, and one for the style information.
The primary keys that match between these files is Style and season. These exist on all 3 of the worksheets. (there are also other matching header fields)
The template for the cost sheet worksheets is named Flex Playground costing sheet.xls. (can be turned into xlt format for this program)
The incoming data files are called Bom view – costing tool.xls, Product Season Line Sheet Print out.xls and Style_S17ADEPAW23_Costsheet_01.xls
The file name of the last ‘style*…xls’ will change, and there should be a user selector.
There should be error messages if data is found to be inconsistent, or the incoming files cannot be loaded.
If a user re-selects the incoming file, the data should ‘overwrite’ onto the existing worksheet.
This should work in excel 2010, and current excel 2016.
This should work on all computers with and operating system, and excel.. there should be no hard coded URL paths if possible.
This should work without a full install package to the computer, and operate like an excel macro.
Hello, I would like to work on your project. I have had many similar work before, only on Windows system and MS Excel, not Apple or Mac Excel. Regards. Relevant Skills and Experience excel, formulas, macros, vba Prop Daha Fazla
Bu iş için 23 freelancer ortalamada $144 teklif veriyor
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of Daha Fazla
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
Hello, I am Excel Expert and VBA Developer I can create for you desirable working file without hard coded urls and macros which will run on any version of office If interested, contact me Thanks Relevant Skills and Ex Daha Fazla
create excel macro Relevant Skills and Experience Excel/VBA Proposed Milestones $200 USD - Completed macro Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets fill Daha Fazla
I am a guru in Excel, and I have experience in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's, charts and more. Relevant Skills and Experience Th Daha Fazla
Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Daha Fazla
> 15Y of VBA, VB, Excel & Access, please clarify details & deadline Relevant Skills and Experience > 15Y of VBA, VB, Excel & Access, financial analysis & planning Proposed Milestones $250 USD - the project
I have done similar tasks in my current organization where I'm working. Thanks.
I would like to complete your project, please give me a chance to improve myself.
Hello, I have read your job description very well.I can deliver the project on time.I can complete this job within the required time period. Regards Subha Sathi Relevant Skills and Experience I have 2 years experienc Daha Fazla