Đã hoàn thành

Excel Macro programming for a Job cost/price calculation sheet


This spreadsheet is used to calculate the costs and selling prices for Jobs.

• Each job can have a varying number of Signs.

• When the user enters a number in the Number of Signs field, the Sign 0 tab is replicated “N” times. The tabs would be labelled Sign 1, Sign 2, Sign 3 etc.

• Sign 0 should end up hidden so it is kept as a blank template. If the user changes the Number of Signs, then the Sign 0 tab can be used to add more Sign tabs.

• The items in the In House Labour section of the Summary tab are the same on each Sign tab. We need a macro to add up all the Tot Hrs across the Sign tabs for the Tot Hrs column for each labour item.

• Summary tab - Subcontract / Install Contractors: We need a macro to pull in the Description of any items entered across the Sign tabs and the corresponding Qty. If more lines are needed, the macro would insert lines.

• Summary tab: Raw Materials/Services: This section needs a macro to pull in any item from the Raw Materials /Services section across the Sign tabs. It should pull in the Description (B42) => map to Description, Qty (F42)=> maps to Quantity, Cost (G42) => maps to Cost, Sell (J42) => maps to Price. Put a “0” in the Billable column. This could be many rows.

• Summary Tab – Raw Materials /Services: Cost and Sell. Need a macro which adds up the total cost and sell from each Sign tab.

* See the "Blank" spreadsheet for programming

* See the "Sample Data" spreadsheet to see the expected outcomes

* See the "Brief" word doc for a more detailed brief.

Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: vba excel manual calculation sheet, excel macro filling excel sheet, excel vba macro programming bids, simple cost sheet format in excel, how to calculate cost per unit in excel, food cost inventory spreadsheet, cost of goods manufactured excel template, cost sheet in excel formula, food cost spreadsheet excel, product costing format, cost of production report format in excel, excel macro programming cut paste, excel macro programming outsource, excel macro expert job, excel macro contract job, excel macro side job, excel macro programming job, excel macro programming jobs, excel macro programming read pdf, ms excel macro programming

Về Bên Thuê:
( 0 nhận xét ) Barden Ridge, Australia

ID dự án: #22406534

Được trao cho:


Hi, As per requirements I will develop Automated Excel with VBA macro for you as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high a Thêm

$300 AUD trong 7 ngày
(81 Đánh Giá)

14 freelancer đang chào giá trung bình $371 cho công việc này


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$400 AUD trong 3 ngày
(738 Nhận xét)

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application. I plan to use a combination of formulas and VBA code to acc Thêm

$400 AUD trong 5 ngày
(232 Nhận xét)

Hi, I can do your project. I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, solver and Visual Basic Application including preparation of avai Thêm

$375 AUD trong 7 ngày
(87 Nhận xét)

Hello Sir Im excel VBA macro and formula Expert :) i can help you build your price calculation in your sheet please ping me for discuss more and im free now to start discuss Sir Thank you Galih

$250 AUD trong 3 ngày
(366 Nhận xét)

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.

$400 AUD trong 7 ngày
(330 Nhận xét)

Hi there. Have you ever thought about having a PDF Template that fulfills all the needs you have mentioned above? Kindly review this link: [login to view URL] Thêm

$450 AUD trong 3 ngày
(81 Nhận xét)

Hey, I reviewed the two spreadsheets and the word document you shared and can create the desired macros that will allow easy replication of Sign 0 template sheet and also calculate the summary numbers like you have de Thêm

$475 AUD trong 10 ngày
(98 Nhận xét)

Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work Thêm

$375 AUD trong 7 ngày
(101 Nhận xét)

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Thank you, Regards.

$500 AUD trong 4 ngày
(108 Nhận xét)

Hi there, Excel guru here with Advance Accounting background Have gone through the project description and sample spreadsheet that you’re looking for to be automated I’m confident that I’ll deliver you required auto Thêm

$264 AUD trong 2 ngày
(76 Nhận xét)

Hi, Would you like to see a quick demo of your project on building an advanced spreadsheet solution for calculating the costs and selling prices for Jobs before you award the project? You can consider it professionally Thêm

$400 AUD trong 3 ngày
(51 Nhận xét)

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$350 AUD trong 3 ngày
(124 Nhận xét)

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Thêm

$250 AUD trong 3 ngày
(84 Nhận xét)