Find Jobs
Hire Freelancers

an excel workbook changed

$30-250 AUD

Cancelled
Posted about 10 years ago

$30-250 AUD

Paid on delivery
Hello, We have a complex quote workbook - see attached. we want to develop this further once we turn this document into a Picking Slip for the Factory for Manufacturing / Delivery. when Picking Slip is selected on the data entry page it needs to remove all pricing and totals from the quote tab and then change the name of each column @ the top of the page to Price Column changed to Supplier Amount Column changed to Order Number. Address Field to say “Delivery Address” Section for Notes/ETA etc…?
Project ID: 5374696

About the project

19 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $126 AUD for this job
User Avatar
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$144 AUD in 2 days
5.0 (800 reviews)
8.8
8.8
User Avatar
Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel tasks, all achieved with 5/5 rating...I read your project descriptions carefully, I reviewed your template. I exactly got what you need and ready to go ahead if you wish to proceed with a top-rated and reliable partner here...I bid a very competitive amount for you. kindly note that I only deliver best quality at a reasonable price...awaiting your (+) reply to start....kind regards,
$157 AUD in 5 days
4.9 (285 reviews)
7.9
7.9
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$200 AUD in 0 day
4.9 (330 reviews)
7.7
7.7
User Avatar
Hi, I am an Excel expert and have completed some projects on similar lines. Kindly have a look at my profile. Had a look at the Excel file provided and can take on the job. Please confirm. Regards, Arul
$150 AUD in 3 days
5.0 (173 reviews)
7.4
7.4
User Avatar
Hi, My name is Jon and I will be happy to help you with the project. Please feel free to message me prior to accepting my bid
$138 AUD in 2 days
4.9 (251 reviews)
7.6
7.6
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$166 AUD in 5 days
4.9 (115 reviews)
6.2
6.2
User Avatar
Greatings! I am chartered accountant and have good hand with excel. I have done a similar type of project recently and am in a good position to do this for you. Thank you
$55 AUD in 2 days
4.8 (50 reviews)
6.1
6.1
User Avatar
Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competetive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$150 AUD in 8 days
4.9 (64 reviews)
5.9
5.9
User Avatar
hey njwcf123, this is feasible. We went through the sheet and if you want, we can export the quote to a word document. BTW - are you using MAC or WINDOWS ? thanks
$55 AUD in 2 days
4.8 (153 reviews)
5.9
5.9
User Avatar
I plan to complete the project via writing an Excel macro contained in a separate XLTM template file. This approach makes further use of the macro very convenient by producing new template based quote workbooks. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. 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. Regards
$138 AUD in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. I have successfully completed similar projects for 'Sadebow'. You may have a look at review provided. Please revert back for any questions/clarifications. Regards! Vikas
$98 AUD in 3 days
4.9 (38 reviews)
5.6
5.6
User Avatar
I am well versed in Excel and I can do this project. However, there are many clarifications I require before I start. Do you want to convert the quote sheet to a picking slip or you want to create a seperate picking slip on another sheet. On your 'quote' sheet i was able to locate 'Price' & 'Amount', but could not find Address or Section. A Delivery Address can be created in any desired position on the sheet, so also Sections for Notes. Please message me so that we can discus further.
$55 AUD in 3 days
4.5 (50 reviews)
5.0
5.0
User Avatar
I have already produced a similar document for a client, allowing "wildcard" searches from a database that copes all possible matches to a new sheet from which the User selects which items to pick. The code puts the selection into an incrementally-numbered Pick List that the user can preview and print and which saves automatically as a new worksheet. I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Normally I provide samples to let you judge my Excel skill for yourself, but as you made this a "restricted" project I can't send an attachment unless you send me a Private Message first. Happy to work under a Confidentiality and Non-Disclosure Agreement if required, and will start as soon as you pay the Milestone into the site. You have not said when the work has to be finished? I have allowed five days to complete the project, so that you can view the work in progress and make any changes you want in that period. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl
$170 AUD in 5 days
4.5 (11 reviews)
4.5
4.5
User Avatar
Hello, I am a Microosft certified trainer (MCP Id: 7531519) and I specialize in MS Excel and automation using VBA and VSTO. I have been delivering training and development solutions on MS Excel for over 9 years. Your requirement is relatively simpler and I can have this taken care off within a day. Before I get started, I would seek, detailed clarification on the fields that you need changed or altered. I am very confident to have this project delivered to your satisfaction and would appreciate if you give me the opportunity to work on this project for you. I look forward to hearing from you. Thank you
$55 AUD in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi, Can you please specify further expected changes please, The ones you have mentioned now can be handled using "If" function and/or "vlookup" function. (If function may have to be used "nested" form, i.e., if function in if function...) May be you can try it yourself, or else I can help you with it. Regards, Swapnil Dhake
$60 AUD in 3 days
5.0 (4 reviews)
1.7
1.7
User Avatar
Hi there, I'm really expert in working with Excel documents. I can develop a macro for you whenever you clicked on a button or changed a cell, it do what do you want.
$55 AUD in 3 days
5.0 (2 reviews)
1.3
1.3
User Avatar
A proposal has not yet been provided
$250 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jan 30, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.