I need a formula to be modified for my pricing sheet

$10-30 USD

已完成

已发布

超过 1 年前

$10-30 USD

货到付款

I am developing an excel file for my estimating. Within the same file I have multiple sheets. We will focus on the PRICING sheet and the CONTRACT Sheet. The Pricing sheet is a table. The table columns are filled with: our services, Pricing, Square foot entry, followed with several more columns breaking down material, labor and profit. It's very close to a proforma. THE PRICING SHEET I sent it locked so you can see I only want the yellow boxes to be used by my workers. The yellow box is to input numbers (ex 500 s/f , in the tile column and spits out a price ) If needed, You can simply unlock the sheet right click on pricing sheet unprotect What I am looking for is a formula to work when i add a number For Expample (500 s/f) I want the details "Tile floor work ... , along with the price, $2500) to appear on the CONTRACT sheet. AND on the CONTRACT Sheet ... I would like all line items directly under one another with no spaces saying "FALSE". I want it to look neat and clean for contract and details purposes.

Excel

Excel VBA

项目 ID: 35890413

关于此项目

14提案

远程项目

活跃1 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@freelancerabdu34

Hi there, I'm an experienced Cost & Management Accountant (CMA) Advanced Level Excel expert. I'll create a formula as per your requirement and will do it IN THE NEXT FEW HOURS. Can we discuss more details about this project? If you are interested, feel free to message me and I will try to help you immediately. Looking forward to connect with you. Regards Abdul Haseeb.

$20 USD 在1天之内

5.0

(6条评论)

1.6

14威客以平均价$31 USD来参与此工作竞价

@hamidr2020

Hello, I am an Excel and VBA/Macro expert. I have checked the attached Excel file and read the requirements. I offer my services to create formulas to align ( neat and clean) all line items directly under one another with no spaces saying "FALSE". We can discuss further details over chat. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid

$30 USD 在1天之内

5.0

(80条评论)

6.0

@merinsinha

Excel VBA expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

$30 USD 在1天之内

4.8

(143条评论)

5.7

@WelcomeClient

Hi There, Ready right now I'm ready to write formula for modified for your pricing sheet . I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer

$20 USD 在1天之内

4.7

(86条评论)

5.4

@jnekam

Hi, I'm data scientist in a company in Canada. I'm looking for side job in data analysis. I will be happy to help you in your projects. I'm proficient on many tools like Excel, Power BI, SQL, Python I did something similar to what you want for a company in California. Thanks!

$20 USD 在7天之内

4.6

(12条评论)

4.0

@asaini800

I am intrusted in job please give me a chance of doing your project as i am fresher give opportunity

$20 USD 在7天之内

0.0

(0条评论)

0.0

@bidyutsonowal664

Hii sir. I have read your project description and I'm interested in your project. I have experienced in Ms Excel, PDF. I will make it at correct time.

$20 USD 在7天之内

0.0

(0条评论)

0.0

@shubhamuttam0123

Skill tally, MS excel ,MS office MS word.

$15 USD 在7天之内

0.0

(0条评论)

0.0

@biswalsidhu123

I assure you i can deliver the project as mentioned.I am very good at ms office and looking forward to work with you sir.

$20 USD 在2天之内

0.0

(0条评论)

0.0

@shanto12

You can use the VLOOKUP function in Excel to achieve your desired result. The VLOOKUP function returns a value from a specified range (your PRICING sheet) based on a matching criteria. Here's how you can set it up: On the CONTRACT sheet, add a column for the square footage input. In the cell under the square footage input, enter the following formula: =VLOOKUP(A2, PRICING!A:D, 2, TRUE) where A2 is the cell containing the square footage input, PRICING!A:D is the range of the PRICING sheet where the data is stored, 2 is the column number that contains the pricing details, and TRUE is to return an approximate match if an exact match is not found. Drag the formula down to fill the rest of the cells under the square footage input column. This will return the pricing details based on the square footage input on the CONTRACT sheet, and display it directly under the corresponding square footage.

$20 USD 在2天之内