Completed

Build me a Pricing solution on excel

Hi there i have attached an excel file.

This file has a few sheets in it.

1) 1st sheet is to be like a search engine which will act as a homepage for the data in other sheets.

2) All the sheets are in same format.

3) user will search by inputting three columns ( Width, Profile, Rim), and search has to return all results matching those three columns across all the sheets.

The coumns will be highlightedin colors as well so the colour has to be transfered over to the main sheet as well (this clasifies if the product is on certain special or not).

i haven't done the pricing rules in all sheets but i will be changing prices all the time so the search has to be friendly with all formulas and stuff.

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

See more: amazon product matching, can build front end excel spreadsheet, product matching script, ebay shipping solution excel, pricing custom excel vba inventory control program, pricing products excel, import pricing dynamics excel, build sorting macro excel, upload excel joomla product database, creating pricing sheet excel, material pricing sheet excel, need solution excel model web, sample pricing sheet excel template, build financial statement excel, excel tiered product pricing formula, software product pricing template excel

About the Employer:
( 0 reviews ) Newcastle, Australia

Project ID: #21380216

Awarded to:

vsprybhanu

Hi, I saw attached file and understood your requirements. I can develop VBA program (macro) to extract data from other sheets according to given value of Width, Profile, Rim and put them into SEARCH sheet with specif More

$75 AUD in 3 days
(90 Reviews)
5.7

11 freelancers are bidding on average $141 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$220 AUD in 4 days
(369 Reviews)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 AUD in 2 days
(317 Reviews)
7.3
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] More

$155 AUD in 3 days
(170 Reviews)
7.1
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje More

$150 AUD in 2 days
(235 Reviews)
6.9
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

$250 AUD in 7 days
(84 Reviews)
6.8
satishtl

Hi - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: -Went through the [login to view URL], based on the Width, Profile, Rim, show the results More

$140 AUD in 5 days
(55 Reviews)
6.1
paulodayto08

Hi Good Day! A serious freelancer here. I want to help you to complete this project. I really know how to do it.. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use my experti More

$50 AUD in 1 day
(35 Reviews)
4.6
writingapp

Hi. Great app writer for your projects. I have writen scraping, excel, csv app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$80 AUD in 3 days
(18 Reviews)
4.4
k551244

Hello.. I have read your post very carefully and I have understood what you want. I am sure I can handle your project perfectly in the quick timeline. Let me know if you have some time to discuss the details further. L More

$140 AUD in 7 days
(2 Reviews)
1.7
franvalmo2018

Hi. I think it can be result with some VBA Macros placed in buttom "ad hoc" so you can put new data in it and recalculate it. If you just want only formulas, well, it can be do as well. Excel has all to make it. I just More

$140 AUD in 6 days
(0 Reviews)
0.0