In Progress

Build an excel sheet to enrol new companies

This is an excel sheet. Any other free option also welcomed. So I already have an 'Enrollment form' which my dealers use to register new customers for different discount scheme. What I want to do is automate the form and make it look good, for example

1. If dealer name ABC is selected in cell A1 from the dropdown box then cell C2 should comprise only of all the existing customers ABC dealer has with him. The list can keep changing based on dealer selected in cell A1.

2. There should also be search option on the cell C2

3. If the search in cell C2 does not show any result, this means this is not an existing customer and in the cell box next to it dealer can input new name of the customer which on the backend (which could be a different sheet) gets added to the list of customers enrolled with that dealer. This way list gets updated. every time a new customer is enrolled by the dealer.

4. The dealer also has an option of uploading supporting document for the customer they enrolled. Find a cell or space for this as well.

This might seem complicated but if you understand it well it is an easy task. Also this is a very serious and confidential task. No half hearted work or incomplete work will be accepted and no money will be released if work is not done as per what is required. I suggest only bid for it if you are an expert in excel.

Skills: Excel, Visual Basic, PHP, Data Processing, Data Entry

See more: service automate excel sheet companies, companies excel sheet dubai, expert excel sheet sample, companies excel sheet, excel sheet companies uk, query excel sheet excel expert needed, uk software companies list excel sheet, balance sheet companies excel sheet, details excel sheet foreign companies, companies excel sheet abu dhabi, expert advice in excel sheet, i am looking to build excel sheet contains multiple sheets, i want an excel expert who works on my excel sheet according to my requirements, excel sheet expert, capital market excel sheet expert freelancer, excel sheet for expert system, need to build custom excel model in new delhi

About the Employer:
( 6 reviews ) Bath, United Kingdom

Project ID: #23935322

Awarded to:

vnegi2016

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o More

$35 USD in 2 days
(0 Reviews)
0.0

13 freelancers are bidding on average $155 for this job

aubrey03

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]

$200 USD in 2 days
(144 Reviews)
6.2
narsim3128

NOTE : I can create an application to implement this process With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. My skill More

$222 USD in 4 days
(45 Reviews)
5.8
finecodervw

Hi, Keen to work on this project. I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional formatt More

$200 USD in 5 days
(172 Reviews)
6.3
Virend7586

Hello, I saw your requirement and I am available to start work. I have 5+ experienced and high skilled for Graphics Design, Photoshop, Illustrator, Internet Research, Scrap Data from Instagram, Excel task, Magent More

$277 USD in 10 days
(51 Reviews)
4.7
jaelahoe

Hi there! Your requirements from 1 to 3 can be done. I can actually do up a userform for you so that it's more intuitive for the user. Can show you a demo before you award. For point 4 though; how are you visualizing More

$250 USD in 3 days
(7 Reviews)
3.5
ARTICLEYOUWANT

Hello, I provide high-quality Virtual Assistant services from data entry and data mining to web research and copy-paste tasks. These assignments may be simple, but you need someone who intuitively understands what you More

$40 USD in 3 days
(2 Reviews)
2.9
FaiqAbbas1999

Greetings, I'm So Obsessed With DataEntry work. I can show you my previous work or you can also give me the demo task. I'm Pretty much confident that I can land 100% on your needs! Please do hit me up. Feel free to ask More

$70 USD in 7 days
(0 Reviews)
0.0
Rishi0401

Hi There - I am an experienced professional and can complete your assignment with desired outcomes. can go in details over connect. looking forward to hear back. Thanks

$155 USD in 3 days
(0 Reviews)
0.0
w3maruf

Greetings, I hope you are feeling very well. I understand your project description. But I want to know more about your project. So, can we discuss more? I am really confident that, I can do this task very effective More

$111 USD in 3 days
(0 Reviews)
0.0
NMnaieem

I can do this within 3 days Relevant Skills and Experience Hi, this is Naieem from Bangladesh. I have 7 years Working experience in this types of activists. Now i am workingat internationalOrganisation For Migratio More

$155 USD in 3 days
(0 Reviews)
0.0
dilupaji1988

i am good in typing, excel, data entry and etc. i would help you in your project with full secrecy. Relevant Skills and Experience data entry, data mining, excel, typing

$155 USD in 3 days
(0 Reviews)
0.0
Servicehour24

Hello, I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd like to help you with confidence and satisfying results. I have professional work More

$150 USD in 3 days
(0 Reviews)
0.0