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)
15 freelancere byder i gennemsnit $130 for dette 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
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?
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
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
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.