Closed

Build me a customized excel sheet

We are into business of decorative lighting. We offer customized lighting solution for homes. We provide the lighting solution in xls, where we take each light point and recommend options. Each line will contain for example:

Light point/Light Area | Light option 1 | Picture | Quantity | MRP | total Value | Discount | Value after discount

Sometimes we have multiple suggestions for each lighting point. what we want is the excel to have some kind of select option at the beginning of each line. When we have multiple options for the light point, only one of the lights should be selected. For example, if there are 3 options (on 3 different consecutive rows), then by default the 1st row light will be selected. there will be option to select the second or third row. Once that is selected, the 1st row should automatically get deselected.

Once the selection is done, the entire row colour should change to indicate selection. Also, the sum total of the value at the bottom of the sheet should get updated to account for only selected lights.

Skills: Business Analysis, Data Entry, Data Processing, Excel, Visual Basic

See more: excel data entry form software, buy custom excel spreadsheets, excel for hire, excel data entry form examples, excel spreadsheet design service, excel data entry form drop down list, excel programmers for hire, data entry in excel worksheet, quantity surveyor excel sheet, i am looking to build excel sheet contains multiple sheets, earthwork quantity calculation excel sheet, managed account performance excel sheet, excel sheet design account, sales quantity excel sheet, area sales quantity analysis excel sheet free

About the Employer:
( 0 reviews ) Bangalore, India

Project ID: #16095975

33 freelancers are bidding on average ₹7292 for this job

haresh31dec1982

I will be able to create such an excel file. If possible can you send sample data to create the file? Stay tuned, I'm still working on this proposal.

₹5000 INR in 3 days
(25 Reviews)
7.2
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a lot of practical experience in Excel, including the use of conditional formatting. Relevant Skills and Experience This is More

₹10000 INR in 3 days
(37 Reviews)
5.1
₹13333 INR in 3 days
(16 Reviews)
4.4
₹5555 INR in 3 days
(14 Reviews)
3.6
MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. Relevant Skills and Experience I have experience in writing macros VBA for Excel Proposed Milestones ₹2250 INR - to do work

₹2250 INR in 2 days
(7 Reviews)
3.1
ibrahimanjum330

Hi, I am an excel expert and I have developed numerous excel solutions, I have even developed a tubewell system in excel. Looking forward to the detailed conversation. Regards, Ibrahim Anjum Relevant Skills and Expe More

₹5555 INR in 3 days
(2 Reviews)
1.9
prembasu24

hi there! I'd like to be considered for your data entry posting. I am a skilled data entry operator with a strong background in Microsoft Excel and Microsoft word. I can help you in every possible way to complete. fo More

₹11111 INR in 15 days
(1 Review)
1.3
henkblommers

What you propose is possible and I could perform this for you. I have a wide range of Excel skills (in work professionally and did some hobby projects). However I propose a dropdown menu instead. Relevant Skills and More

₹10000 INR in 2 days
(0 Reviews)
0.0
nimnaonline

i have experience Relevant Skills and Experience i have experience Proposed Milestones ₹7777 INR - ..

₹7777 INR in 3 days
(0 Reviews)
0.0
sorooshsh

A proposal has not yet been provided

₹11111 INR in 5 days
(0 Reviews)
0.0
₹11111 INR in 3 days
(0 Reviews)
0.0
jalileng

A proposal has not yet been provided

₹8888 INR in 4 days
(1 Review)
0.0
JanarthananR

I can do this perfectly. Give me the samples and if possible a text we will discuss

₹5000 INR in 3 days
(0 Reviews)
0.0
arpandey123

A proposal has not yet been provided

₹4444 INR in 3 days
(0 Reviews)
0.0
mohannegi

I have Good typing speed Relevant Skills and Experience Word Excel Proposed Milestones ₹7777 INR - Word Excel

₹7777 INR in 3 days
(0 Reviews)
0.0
beverlyco

I am expert in excel jobs like data entry,spreadsheets and typing Relevant Skills and Experience I'm a freelancer and with experience in excel jobs Proposed Milestones ₹13888 INR - typing,data entry and spreadsheets

₹13888 INR in 2 days
(0 Reviews)
0.0
kanthyahoo777

A proposal has not yet been provided

₹2777 INR in 3 days
(0 Reviews)
0.0
sunprah2018

I have expertise in excel. I assure you to deliver high quality work in stipulated time period. Relevant Skills and Experience Excel Macros Proposed Milestones ₹10000 INR - Understand the business need and then creat More

₹10000 INR in 5 days
(0 Reviews)
0.0
ohernandez31

Hello! I can deliver your project within 2 days. It will let you select the options you mentioned and any other variable you want so it will be very easy to use it. Oskar Relevant Skills and Experience I am an exper More

₹2000 INR in 2 days
(0 Reviews)
0.0
nidhi70

A proposal has not yet been provided

₹16666 INR in 5 days
(0 Reviews)
0.0