Convert Sales order in Excel to Automatic Email

Κλειστό Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

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.

Excel Visual Basic

Ταυτότητα Εργασίας: #18951036

Σχετικά με την εργασία

27 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 4 χρόνια

27 freelancers κάνουν προσφορές κατά μέσο όρο $131 για αυτή τη δουλειά

cgullapalli

Hi, I am good at Excel VBA and sending the email. Looking forward to discuss in the chat. I have referred the attachment. -Chandra

$150 USD σε 2 μέρες
(855 Αξιολογήσεις)
7.9
schoudhary1553

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. Περισσότερα

$220 USD σε 3 μέρες
(315 Αξιολογήσεις)
7.8
paris2785

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 Περισσότερα

$140 USD σε 1 μέρα
(204 Αξιολογήσεις)
7.3
dgled

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 Περισσότερα

$250 USD σε 3 μέρες
(79 Αξιολογήσεις)
7.0
TonmoyRoy111

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

$150 USD σε 3 μέρες
(314 Αξιολογήσεις)
6.8
MohsanEijaz

I am interested you project, As I have experience with excel and vba. Please review my profile. Mohsan

$120 USD σε 3 μέρες
(83 Αξιολογήσεις)
6.3
chriskerpini

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 Περισσότερα

$155 USD σε 1 μέρα
(75 Αξιολογήσεις)
6.5
branislavm

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

$155 USD σε 3 μέρες
(40 Αξιολογήσεις)
6.1
lightingdavid

Hello. As a Excel VBA expert, i 'm interest to your project. I hope to work with you. Contact me please. Thank you.

$140 USD σε 3 μέρες
(98 Αξιολογήσεις)
5.9
sloker18

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 Περισσότερα

$150 USD σε 3 μέρες
(81 Αξιολογήσεις)
5.8
nvchien94

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 Περισσότερα

$40 USD σε 1 μέρα
(96 Αξιολογήσεις)
5.4
urielbaray

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 Περισσότερα

$95 USD σε 3 μέρες
(32 Αξιολογήσεις)
5.1
vsprybhanu

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 Περισσότερα

$90 USD σε 3 μέρες
(71 Αξιολογήσεις)
5.5
sonarkaushik

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 Περισσότερα

$144 USD σε 3 μέρες
(45 Αξιολογήσεις)
5.6
gsanggara

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 Περισσότερα

$100 USD σε 2 μέρες
(23 Αξιολογήσεις)
4.0
romanapanovich

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

$90 USD σε 2 μέρες
(2 Αξιολογήσεις)
3.5
ielucerotrad1

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 Περισσότερα

$100 USD σε 4 μέρες
(6 Αξιολογήσεις)
2.4
writingapp

Hi. I have writen excel macros for many years. I am ready to write your project. Thank you for visiting my profile

$35 USD σε 1 μέρα
(5 Αξιολογήσεις)
2.3
Dinfo12

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 Περισσότερα

$100 USD σε 3 μέρες
(1 Κριτική)
1.6
TumblingWave

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 Περισσότερα

$130 USD σε 3 μέρες
(2 Αξιολογήσεις)
1.2