Convert Sales order in Excel to Automatic Email
$30-250 USD
Πληρώθηκε κατά την παράδοση
We have a simple sales price list with columns as follows :
Category_code, Source : categories sheet first col
Part_number , A string containing hyper link
Description , A string
Category Description, Source : categories sheet based on the category code
Price 1 : if part number is empty copy from category sheet : column price 1
price 2 :if part number is empty copy from category sheet : column price 2
price 3 :if part number is empty copy from category sheet : column price 3
Order Quantity : default 0 , if value >0 , multiple price1 or price2 or price3 ( depending on the volumes in categoy sheet )
by Order_quantity into Item_cost
Item_cost - result field
Comment : text
Calculate Sub_total after each change ( Excel)
If Sub_total > parameters.Free_Sheepment_minimum_order Shipment_cost is Zero otherwise = parameters.shipment_cost
Total Cost = ( Sub_total + shipment_cost) * (100 + parameters.vat_percentage)/100
Near the Total_cost add a button "Make_Order" .
The button will create an Excel report containing all the lines with Item_cost > 0 plus all the summary data.
This Excel report should be sent automatically to the email address in parameters.send_to email address.
The email title should be taken from parameters.send_to_email_title
The top part of the price_list sheet must be fixed and include another copy of the "Make_Order" button.
The summary part of the price_list sheet must be float and appear all the time at the bottom of the screen even if its in line 5000.
Ταυτότητα Εργασίας: #18951036
Σχετικά με την εργασία
27 freelancers κάνουν προσφορές κατά μέσο όρο $131 για αυτή τη δουλειά
Hi, I am good at Excel VBA and sending the email. Looking forward to discuss in the chat. I have referred the attachment. -Chandra
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Περισσότερα
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel to retrieve data from Parameters and Categories sheets a Περισσότερα
Shalom, I can suggest to you a module in Microsoft Excel which sends sales order by email (by Microsoft Outlook). The application allows you to open/edit/delete records and shows the documents by filters. There is a s Περισσότερα
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
I am interested you project, As I have experience with excel and vba. Please review my profile. Mohsan
Hello, My name is Chrys. As you can see from my profile, I have 18+ years experience working with Excel/VBA and 14 years teaching them both (all levels). I can certainly do excellent work with your project. Please c Περισσότερα
Hello! Here is my offer to automate your workbook. I will try to use formulas as much as possible, but for email, I will need to use VBA. Are you using Outlook? Regards, Branislav Mihaljev
Hello. As a Excel VBA expert, i 'm interest to your project. I hope to work with you. Contact me please. Thank you.
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t Περισσότερα
Hello. I am an Excel VBA coder with 4 years + experience. After read tour requirement, I can give you some scripts then U can click 1 button to do all your process. Email will be automatically created in PDF or excel a Περισσότερα
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Περισσότερα
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will create excel vba program to fulfill all requirements. I saw attached files and unde Περισσότερα
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you Περισσότερα
Hi giltenne284, I know advance excel very well and will complete your task soon with high quality in place. I will rebuild your current file into more interactive template with final option to send emaila utomaticaly Περισσότερα
Hi I can develope it on Google Sheet. I recommend to use Google sheet instead of Excel because in future it provide more possibilities to integrate with internet processes etc
I can do the job! The e-mail will be sent by outlook, is that ok? I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoi Περισσότερα
Hi. I have writen excel macros for many years. I am ready to write your project. Thank you for visiting my profile
Hi - I am Ashish. Thanks for sharing your Data Entry requirement and I will be more than happy to help you. Let me share with you my expertise with Data Entry. I have 8+ Years of experience now and have been do Περισσότερα
I can do this for you, no trouble. I'm just finishing another MS Office programming project on Freelancer here: https://www.freelancer.com/projects/software-architecture/Database-Report-Application/?w=f . I have years Περισσότερα