Devam Ediyor

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.

Beceriler: Excel, Excel Macros, Excel VBA

Daha fazlasını görün: 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

İşveren Hakkında:
( 2 değerlendirme ) Moscow, Russian Federation

Proje NO: #14875265

Seçilen:

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 Daha fazlası

3 gün içinde 110$ USD
(86 Değerlendirme)
5.9

23 freelancer bu iş için ortalamada 144$ teklif veriyor

in 2 gün içinde200$ USD
(249 Değerlendirme)
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 Daha fazlası

in 3 gün içinde180$ USD
(189 Değerlendirme)
7.1
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.

in 3 gün içinde200$ USD
(199 Değerlendirme)
6.8
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 Daha fazlası

in 5 gün içinde277$ USD
(85 Değerlendirme)
6.3
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.

in 10 gün içinde200$ USD
(112 Değerlendirme)
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 Daha fazlası

in 3 gün içinde200$ USD
(110 Değerlendirme)
6.4
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 Daha fazlası

in 3 gün içinde333$ USD
(34 Değerlendirme)
5.7
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 Daha fazlası

1 gün içinde 30$ USD
(32 Değerlendirme)
4.7
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

in 5 gün içinde250$ USD
(10 Değerlendirme)
4.8
in 4 gün içinde222$ USD
(3 Değerlendirme)
3.0
in 3 gün içinde75$ USD
(1 Değerlendirme)
1.9
heybhai

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

in 5 gün içinde55$ USD
(0 Değerlendirme)
0.0
Santoshpradhan00

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

in 5 gün içinde30$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
gabrieltabares05

A proposal has not yet been provided

in 5 gün içinde55$ USD
(0 Değerlendirme)
0.0
joshwin77

creatively design macro for ease Ur work

in 2 gün içinde35$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde277$ USD
(0 Değerlendirme)
0.0
Slavik159

A proposal has not yet been provided

in 5 gün içinde55$ USD
(1 Değerlendirme)
0.2
pitr77

A proposal has not yet been provided

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
in 5 gün içinde35$ USD
(0 Değerlendirme)
0.0