Find Jobs
Hire Freelancers

Do some Excel Work

$250-750 USD

Closed
Posted about 10 years ago

$250-750 USD

Paid on delivery
Hello, I wish to modify an existing spreadsheet to send an email when a cell reaches a certain value. I also would like to dismiss the value when data is entered into the following cell. I found an example/tutorial online at '[login to view URL]', but I am not skilled enough to apply this information to my existing document. I am unsure of how much information to include in this initial request. Specific information: Tab: DWG Orders Column F 'Date Ordered' Column G 'Today' Column H 'Days Pending' Column I 'Date Received' When today's date reaches 5 business days from the Date Ordered, I would like an email sent to a specific address. I would also like to void this action when data is entered into the Date Received cell. I suppose we could get sassy and have the body of the email 'list' the applicable row data (I.E. 113T1958-8 LWG Boeing KUTD # 26911 10/17/13 02/17/14 88) or whatever. I realize this is embarrassingly lowbrow stuff, but that is where I am. Thank you very much for your time.
Project ID: 5451924

About the project

23 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
23 freelancers are bidding on average $348 USD for this job
User Avatar
Respected sir, EXPERTS HERE!!! We are experts and experienced in Data Entry, Data Processing, Data Research, Web Search, Web Scraping, Copy Typing, MS Office and many other tasks. We saw the project description and got complete idea about it. We have worked and completed many similar projects like this before. You can check our profile too. Give us a chance to serve you, and we will never let down your expectations from us. Work will be completed and delivered in timeframe. Awaiting for your prompt reply. Thank you. Happy2helpp
$360 USD in 7 days
5.0 (70 reviews)
6.9
6.9
User Avatar
Hello, I have degree in business and use excel every day as part of my job. I can give you the solution you seek. Best regards.
$250 USD in 4 days
5.0 (177 reviews)
6.7
6.7
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.
$277 USD in 10 days
4.9 (172 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$270 USD in 3 days
4.9 (25 reviews)
5.7
5.7
User Avatar
Good day, I am expert in 2d and 3d design in Autocad. I am working with high performance computer in order to make high Q outcomes and rendering. I am working with Autocad since 1999. Please check my portfolio to see my passed projects. Regards.
$250 USD in 4 days
5.0 (70 reviews)
5.8
5.8
User Avatar
Hi, We can use combination of Target rows, Workdays and VBA to achieve the required functionality. It can be completed in 5-7 days. I prepared something similar to send chat messages on Gtalk based on change in cell values (through excel). I believe I can help you in current project as well. My background: 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. Please revert back for any question/comment. Regards! Vikas
$263 USD in 10 days
4.9 (39 reviews)
5.7
5.7
User Avatar
I am interested working this task. I can rest assured to fulfill this task in timely manner. I am looking forward for your response to get started working thank you. Regards, Jay
$400 USD in 5 days
4.6 (88 reviews)
5.7
5.7
User Avatar
Hello, Having gone through your requirement; i am provide high quality work. I feel suitable enough for the role hence my application for the project. I am happy to work with you on this project to achieve set objectives and targets.
$388 USD in 10 days
4.7 (104 reviews)
5.5
5.5
User Avatar
Hi, I build robust, strategic business solutions period. Recent project was for sending emails from Excel and synchronizing Outlook (please look at the review for this one)... PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.
$305 USD in 10 days
5.0 (4 reviews)
4.7
4.7
User Avatar
* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the projects awarded to me here. I can understand the urgency of the employers and work to finish the project in time. Moreover, As you can see my profile, I am quite a new freelancer. I love to keep my reputation up to the mark. If you wish to award the project to me trusting my abilities, you are always welcome to contact me anytime of the day. Let us have a chat on the project details before I take the responsibilities, As this will help me understand the project clearly. So that We won't be in a situation where our time won't be wasted later. Lastly, I would like to tell that I stand by my words and I assure you that your expectations will be satisfied completely by my work. You will be happy with my work at the end. As a request, I ask you kindly to offer me this project's responsibilities and pave me a path to stand out of the crowd in Freelancer. Thanks in advance. With regards, SathyaNarayana Singh. J.
$250 USD in 10 days
4.9 (9 reviews)
3.5
3.5
User Avatar
Hello Christopher, Thank you for posting this project. I have thoroughly reviewed your requirement and I would be happy to have this taken care off for you. I can have the solution developed using traditional VBA programming or, I could also use VSTO to develop a com addin that you can use to install on any computer to perform similar tasks. The later approach will involve more robust coding, UI functionalities, an aesthetic appeal (as it exposes the dot net framework within excel). I will need no more than 1 day to complete this task at hand. My code is clean, concise and always easy to understand since its very well documented, I will also explain you how to use the application and would be happy to revise/ improvise it to your satisfaction after the initial submission. I would also be happy to suggest improvisations to your existing layout to best suit your needs. By way of introduction, I am a Microsoft certified trainer (MCP Id: 7531519) and I have been offering training and automation solutions on MS Excel to corporate staff for over 9 years. I look forward to hearing from you to discuss this further. I would appreciate if you would initiate a private message to discuss this further with me, Thank you very much.
$250 USD in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi, We are interested in your job and ready to start. We have experience in this field for more than 8 years. Thank You.
$277 USD in 1 day
5.0 (3 reviews)
1.2
1.2
User Avatar
Non hai ancora fornito una proposta
$555 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very interested in taking on this project! I have 10 years office experience and I am now a stay at home mom! I have the time to commit to doing a great job! Hope you consider my bid! Thank you!
$400 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Following are the reasons that makes me the best candidate for the project: 1) I am originally from Nepal and currently living in US. My English is very good and so is my typing speed, which are very essential for the project. 2) I have high speed internet connection at my home. 3) I am very dedicated/motivated person and thus follow work related rules and regulations and I will efficiently finish my assigned task before the deadline. Skills: Good English, Fast typing speed, HTML,Data Entry,Excel
$277 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day, I am new to Freelancer, so this will be a first project for me. Have a couple of weeks open so trying something new...I have plenty experience with VBA and Excel, since I exclusively used it for financial modeling during my MBA thesis I just finished two weeks ago. The implementation should be fairly straightforward. The only requirement I have not implemented before is the email part, but it should not be too complicated. Bid is high(er), since I will not deliver something inferior, and it just is not worth my time otherwise. Please clarify the following: 1)statement: "I also would like to dismiss the value when data is entered into the following cell" 2)If the layout of the tab(sheet) is always the same - starts at row 3 and columns fixed etc. We also need to clarify how the sheets are used. Do you only have one workbook that is a "working copy" and the file just grows, or do you have monthly workbooks from a template etc. Should be able to deliver within 2-3 days. Specified 7 days to play it safe in-case there is an issue. Regards Wilhelm de Beer
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I assure you that i will complete this task with in defined time period and you will be happy after assign this task to me.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
On the contrary, this is exciting stuff for me. Would love to be able to help you out. You have defined 50% of the problem, and when you work with me we can clarify the rest. Essentially I would write IF THEN code in VBA which will work with Excel and feed the outcome of the code to another program that would work with the email system. Which email system would you want this to work with? That is one of the 50% of clarity missing as of now. Anyway, would love to do this for you. Might take a week for to develop, test, and deliver, but then I am quoting a fixed rate of $600 so you know exactly what it will cost you.
$600 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Feb 18, 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.