Excel Cost sheet builder.

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.

Taidot: Excel, Excel Macros, Excel VBA

Näytä lisää: free construction cost estimate excel template, building estimate format in excel free download, residential construction cost estimator excel, free building estimate format in excel, construction estimating using excel free download, building estimate format in pdf, construction estimating excel spreadsheet, excel sheets cost estimation civil engineering, product cost sheet excel format, i have a requirement for copying pasting contacts information from a website onto an excel sheet which i will provide i have upl, i have a requirement for copying & pasting contacts information from a website onto an excel sheet which i will provide, i have a requirement for copying & pasting contacts information from a website onto an excel sheet which i will provide i have u, cost sheet excel construction, excel construction cost sheet, cost sheet template excel

Tietoa työnantajasta:
( 2 arvostelua ) Moscow, Russian Federation

Projektin tunnus: #14875265

Myönnetty käyttäjälle:


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 Lisää

110 $ USD 3 päivässä
(86 arvostelua)

23 freelanceria on tarjonnut keskimäärin 144 $ tähän työhön

200 $ USD 2 päivässä
(249 arvostelua)

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 Lisää

180 $ USD 3 päivässä
(189 arvostelua)

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.

200 $ USD 3 päivässä
(199 arvostelua)

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 Lisää

277 $ USD 5 päivässä
(85 arvostelua)

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.

200 $ USD 10 päivässä
(112 arvostelua)

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 Lisää

200 $ USD 3 päivässä
(110 arvostelua)

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 Lisää

333 $ USD 3 päivässä
(34 arvostelua)

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 Lisää

30 $ USD 1 päivässä
(32 arvostelua)

> 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

250 $ USD 5 päivässä
(10 arvostelua)
222 $ USD 4 päivässä
(3 arvostelua)
75 $ USD 3 päivässä
(1 arvostelu)

I have done similar tasks in my current organization where I'm working. Thanks.

55 $ USD 5 päivässä
(0 arvostelua)

I would like to complete your project, please give me a chance to improve myself.

30 $ USD 5 päivässä
(0 arvostelua)

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 Lisää

100 $ USD 3 päivässä
(0 arvostelua)

A proposal has not yet been provided

55 $ USD 5 päivässä
(0 arvostelua)

creatively design macro for ease Ur work

35 $ USD 2 päivässä
(0 arvostelua)

I am working as Senior Software Developer. I have 7 + years experience in .NET with C#,VB.NET,VBA, Excel programming, AWS, ASP.NET, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and HTML. Stay tuned, I'm still Lisää

277 $ USD 3 päivässä
(0 arvostelua)

A proposal has not yet been provided

55 $ USD 5 päivässä
(1 arvostelu)

A proposal has not yet been provided

155 $ USD 3 päivässä
(0 arvostelua)
35 $ USD 5 päivässä
(0 arvostelua)