En cours

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.

Compétences : Excel, Excel Macros, Excel VBA

Voir plus : 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

Concernant l'employeur :
( 1 commentaire ) Moscow, Russian Federation

N° du projet : #14875265

Décerné à :

nagyzoltan68

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 Plus

110 $ USD en 3 jours
(83 Commentaires)
5.7

24 freelance ont fait une offre moyenne de 142 $ pour ce travail

200 $ USD en 2 jours
(249 Commentaires)
7.6
schoudhary1553

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 Plus

180 $ USD en 3 jours
(177 Commentaires)
6.9
P0L

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 en 3 jours
(180 Commentaires)
6.7
sandroshubladze

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 Plus

277 $ USD en 5 jours
(81 Commentaires)
6.1
dpune

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 en 10 jours
(110 Commentaires)
6.2
paris2785

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 Plus

200 $ USD en 3 jours
(107 Commentaires)
6.3
dgled

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 Plus

333 $ USD en 3 jours
(30 Commentaires)
5.6
AlexandrUKR

> 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 en 5 jours
(10 Commentaires)
4.8
royalcalif

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 Plus

30 $ USD en 1 jour
(28 Commentaires)
4.4
222 $ USD en 4 jours
(2 Commentaires)
2.9
heybhai

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

55 $ USD en 5 jours
(0 Commentaires)
0.0
Santoshpradhan00

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

30 $ USD en 5 jours
(0 Commentaires)
0.0
subhasathi75

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 Plus

100 $ USD en 3 jours
(0 Commentaires)
0.0
RavinderNegi

A proposal has not yet been provided

100 $ USD en 3 jours
(0 Commentaires)
0.0
gabrieltabares05

A proposal has not yet been provided

55 $ USD en 5 jours
(0 Commentaires)
0.0
joshwin77

creatively design macro for ease Ur work

35 $ USD en 2 jours
(0 Commentaires)
0.0
vinod150987

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 Plus

277 $ USD en 3 jours
(0 Commentaires)
0.0
Slavik159

A proposal has not yet been provided

55 $ USD en 5 jours
(0 Commentaires)
0.0
pitr77

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
35 $ USD en 5 jours
(0 Commentaires)
0.0