I gang

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)

Færdigheder: Excel

Se mere: fun excel, enabled plus, master excel, row spreadsheet, inc, formulas sheets, excel formatting, customer spreadsheet, excel sheet formatting, excel column update, function order, 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, item description spreadsheet, spreadsheet item descriptions

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

Projekt-ID: #6042458

Tildelt til:

JonNxt

Hi there, I\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ Mere

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

15 freelancere byder i gennemsnit $130 for dette job

zExcel

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)
6.2
nagybatonyi

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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)
4.6
sawangupta

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)
4.6
vikas0903

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 Mere

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

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: 1.Real Estate (video demonstration) 2.Orders (video demonstrat Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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)
0.0
jitinchadha1984

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 Mere

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

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 Mere

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

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)
0.0