Devam Ediyor

Design 2 Macros to read and condense a large amount of data into simple tables

We have a main excel spreadsheet with a lot of data which we want to condense down into a simple monthly order that is automatically populated into MS outlook ready to send to our clients. This will be done through the use of Macros ideally as these reports will be run every month. Each macro's task is listed below:

Macro 1 - This macro will condense all the data from the main spreadsheet into the small order table ready for input into MS Outlook.

Marco 2 - This will push the order table into outlook and needs to be selective so we can pick and chose which customers to send this to.

Attached is a workflow example of what is required.

Beceriler: Veri İşleme, Excel, Microsoft Office, Microsoft Outlook, Visual Basic

Daha fazlasını görün: load data peoplesoft tables component interface, display data values excel chart using vba macros, php extract data html tables, data base example large fire department, php extracting data html tables, data base tables need online ordering system, clear data access tables, aspnet gridview data different tables, regex extracting data html tables, converting data word tables excel, extract data html tables php, harvesting data html tables, screen scrape extracting data html tables, view data gridview tables vbnet, extracting tabular data html tables php code, extract data html tables

İşveren Hakkında:
( 2 değerlendirme ) Melbourne, Australia

Proje NO: #14771189

Seçilen:

koolsidz

NOTE: This is a temporary bid. Please share exact details so that I can give you an exact bid. Your attached pdf talks about viber? Relevant Skills and Experience My Credentials: 20+ of VB Experience. [url removed, login to view] Daha fazlası

5 gün içinde 250$ AUD
(172 Değerlendirme)
6.6

26 freelancers are bidding on average $364 for this job

jaylancer43

#1 Excel Web Scrapping expert on [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view]) Relevant Skills and Experience I a Daha fazlası

in 4 gün içinde500$ AUD
(491 Değerlendirme)
8.0
maverick44000

Hello, I am highest rated Excel and Outlook freelancer. I can write the VBA macro within 2 days. Please award the work so I may continue. Thank you, Usman Relevant Skills and Experience VBA, Excel, Outlook Proposed Daha fazlası

in 2 gün içinde400$ AUD
(108 Değerlendirme)
7.4
seaanddream

Hi, my name is Sevinc. I read your "Design 2 Macros" project descriptions carefully before bidding. I checked the attached workflow as well..I got what you need. Relevant Skills and Experience I am 5-star excel and v Daha fazlası

in 5 gün içinde300$ AUD
(235 Değerlendirme)
7.4
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Daha fazlası

in 4 gün içinde350$ AUD
(193 Değerlendirme)
7.0
avinav606lx

Hey Mate, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience Relevant Skills and Experience Lets disc Daha fazlası

in 10 gün içinde277$ AUD
(138 Değerlendirme)
6.3
ksriniravi

I can develop the macro for your 2 requirements for AUD 250. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 1 Daha fazlası

in 5 gün içinde250$ AUD
(90 Değerlendirme)
6.0
dgled

Hi, I did a similar project that creates PDF quotations from database in excel (customer/catalogue/price/personal discount lists ) and sends the PDF by Microsoft Outlook ..... Relevant Skills and Experience (in includ Daha fazlası

in 10 gün içinde750$ AUD
(32 Değerlendirme)
5.7
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Daha fazlası

in 4 gün içinde250$ AUD
(51 Değerlendirme)
5.8
abhinovpankaj

Have worked on several similar [url removed, login to view] in VBA and Scripting Relevant Skills and Experience VBA,VBS,Windows,C#.NET Proposed Milestones $343 AUD - VBA

in 10 gün içinde343$ AUD
(47 Değerlendirme)
5.4
Rahul2012

Hello Sir, As per my understanding macro1 : will be running to filter data for order table from maim sheet and attach to ms outlook for sending mailto to configured recepients . macro2: I need some more info for ho Daha fazlası

1 gün içinde 250$ AUD
(22 Değerlendirme)
5.2
zu02

I'll do it via Ms Access GUI with Excel automation Relevant Skills and Experience vba, ado, sql, excel object model Proposed Milestones $777 AUD - default

in 10 gün içinde777$ AUD
(23 Değerlendirme)
5.5
carlosperezit

Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Habilidades y experiencia relevante Daha fazlası

in 10 gün içinde555$ AUD
(29 Değerlendirme)
4.9
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills a Daha fazlası

in 7 gün içinde333$ AUD
(29 Değerlendirme)
4.5
dvcontact

Hi, If you are looking for a professional and reliable Excel/VBA expert with proficiency in data analysis, I'm your ideal candidate. Relevant Skills and Experience For over 10 years I’ve been building and administerin Daha fazlası

in 5 gün içinde250$ AUD
(8 Değerlendirme)
3.9
OvaisNazir

I have carefully read your project description, and i can perfectly Design 2 Macros to condense all the data from the main spreadsheet into the small order table. Relevant Skills and Experience Data Processing, Excel, Daha fazlası

in 3 gün içinde250$ AUD
(4 Değerlendirme)
4.0
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i Daha fazlası

in 3 gün içinde277$ AUD
(11 Değerlendirme)
3.3
1 gün içinde 444$ AUD
(2 Değerlendirme)
2.6
in 3 gün içinde250$ AUD
(4 Değerlendirme)
3.1
shakerhany

Please read, I checked your project description, and read it carefully, and I can CONFIRM, I can get this done within 2 Days max, I've done a very very similar project at my work for Vodafone, Relevant Skills and Expe Daha fazlası

in 2 gün içinde250$ AUD
(10 Değerlendirme)
2.7
chintuag

Dear Hiring Manager, I have previously worked on a similar project on another freelancing website where information was extracted from PDF and sent as an email to the recipients automatically. This was done with the h Daha fazlası

in 3 gün içinde253$ AUD
(2 Değerlendirme)
1.5