Excel Spreadsheet inc. macros

I have a spreadsheet with 4 worksheets - 3 containing Item Number, Title, Description & Cost & 1 containing a glossary of Item number & Description - to this I have added an 'enabled column'

On a new worksheet if item is enabled on Glossary (=Y) then the item number, name & Cost should be referenced from the other 3 work sheets & displayed on one row - this row also will have provision for customer's cost (which the client will enter directly into this master worksheet, but should probably be stored on another), +10% + 20% & difference between the customer's cost & one of the retrieved costs from a work-sheet that I'll specify.

Now the fun part ...

If the client clicks on an item row, either the row below reveals or a window opens below the row revealing the relevant descriptions retrieved from each worksheet PLUS any comments that the client may have entered.

Needs a search function, order by Item number & order alphabetically (on description)

Will also probably require some conditional formatting to warn if there are any restrictions specified in the description on any of the worksheets.

I envisage that the 'Master Worksheet' will be compiled once, but needs an update function if a new item is added, subtracted or price changed - this can be automatic or via an Update button

Prototype available to successful bidder (built using formulas & filters which I realise are not powerful enough)

Evner: Excel

Se mere: the prototype part 1, fun with excel, enabled plus, master excel, row spreadsheet, inc, formulas sheets, Excel Formatting, customer spreadsheet, excel sheet formatting, excel column update, function order, google spreadsheet advanced conditional formatting, excel window, excel macros spreadsheet macro, price work spreadsheet, work cost item excel, master excel sheet, prototype excel, excel spreadsheet formulas macros, automatic excel, excel customer sheet, price excel spreadsheet work, excel work order, work order excel

Om arbejdsgiveren:
( 3 bedømmelser ) Wendouree, Australia

Projekt ID: #6042458

Tildelt til:


Hi there, I\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ Flere

$100 AUD in 2 dage
(6 bedømmelser)

15 freelancers are bidding on average $130 for this job


Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions

$166 AUD in 2 dage
(83 bedømmelser)

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are inclu Flere

$133 AUD in 3 dage
(53 bedømmelser)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

$200 AUD in 7 dage
(35 bedømmelser)

Hello, It's easy to implement the Search button. Also the conditional formatting, given you can provide me the possible restrictions and desirable formatting. The update can be implemented dynamically (as items or p Flere

$150 AUD in 2 dage
(20 bedømmelser)

HI, i can do it. correct if i misunderstand what you need: 1/ you have workbook with 4 spreadsheet: 1 master and 3 other with product data 2/ you need to display the data (collected from these 4 sheets) of any selec Flere

$155 AUD in 15 dage
(20 bedømmelser)

Hi, I have lots of experience with excel automation using vba macros and can help you in short terms with this task Can you provide a sample spreadsheet on which I can work?

$188 AUD in 3 dage
(5 bedømmelser)

Hi , I can help you with your requirement. I have closed more than 150 excel related projects. Please share the excel sheet, i can give a small demo. Regards Sawan

$105 AUD in 3 dage
(10 bedømmelser)

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc Flere

$115 AUD in 3 dage
(7 bedømmelser)

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Flere

$95 AUD in 5 dage
(20 bedømmelser)

Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience with spreadsheets, complex formulas and macros too. If you send me the file I can show my work. Check my e Flere

$94 AUD in 3 dage
(12 bedømmelser)

Hello. My name is Brent and I am an Excel VBA developer. I have completed many similar projects here on the site that incorporate basic Excel functionality like lookups on other sheets, searches across sheets, dat Flere

$90 AUD in 3 dage
(18 bedømmelser)

Hello Sir, This is Moshiur and it would be my pleasure to do this job. In profession I am an engineer and working by using Macro in Excel sheet almost everyday for many purposes. I am confident enough to do this jo Flere

$111 AUD in 3 dage
(1 bedømmelse)

Hi This project so nice and lovelyl i had comple many projecy like this. Just need some data and this will be done perfectley. Dont be hesitate to release this project to me. Regards Souvenirone

$155 AUD in 3 dage
(0 bedømmelser)

Dear Sir / Madam Greetings for the day!! We are group of talented professionals working in the field of Academic Writing /S.E.O / Content Writing / Article Writing / Data Entry / PowerPoint / Presentations / W Flere

$120 AUD in 2 dage
(0 bedømmelser)

Hi. I am an Excel macro expert. I will satisfy you. I have experienced financial management, assets keeping by using of Macro. If you want success, I can perfectly complete your project. It will be appreciated if Flere

$67 AUD på 1 dag
(0 bedømmelser)

Hi, sir. I think i am an expert in excel and word. if you contact with me, you will know my typing speed is very good. i can do it fast, correct. regards.

$100 AUD in 3 dage
(0 bedømmelser)