Closed

MS Word List creation from a Excel set of data similar to a Direct Mail - Project

Task/Job detailed description:

I have 2 MS/Word Files that are basically a list/table (there is a list with data example as "place holder" and make it easier for you to understand how that list will be with data. We will call it "Template".

- Each page have a specific header (Logos and text)

- Each page have a grid-like table that needs to be filled (see the Excel part below)

- Each page have a specific footer that makes part of the grid/table like

- This footer has the number of items on that grid

- This footer counts the total of the previous page too

- The page count starts in "2"

* The MS Word is attached here

I have 2 Excels spreadsheets. Each one will be used to fill one of the MS Word.

I need to have data from Excel being added to Word according to a set of rules (mapping will be provided).

Much like a Mail List process;

I Have a detailed mapping done for each field/list

I need to have a Macro/VB that provides me with a Button that I can do that as many times as I may need.

- Like if I fix a record on Excel I can run everything again.

Let say Excel has 1000 records. Each Grid affords 26 Items. That means we will have:

1 - First page = Heater + Text

2 - From the second page we will need grid/table being filled with data from Excel (26 records);

3 - That will make 38 pages with 26 records and page 49 with 12 records ( that will bring the total of 1000 records/rows)

- After it's done I need the Macro/VB to save the Word documents being saved in .PDF, keeping exactly the format its have in the world.

- The font must be exactly the font on the MS Word Templates (Font type and size).

In summary:

2 Word Files

2 Excel Files

Data from 1 Excel being added to 1 Word..

Both Documents are very similar, a different set of data but overall very similar.

***VERY IMPORTANT 1 *** - Please make sure your BID is the final. I will not negotiate after and will take your BID into consideration... so no negotiation after.

***VERY IMPORTANT 2 *** I need that to be done in 1 day (24 hours max) after being selected.

Thanks,

Gus.

Thanks.

Gus.

Skills: Excel, Word, Excel VBA, Excel Macros

See more: word list creation, companies providing data entry jobs ms word ms excel, ms word custom document properties set, ms word form field excel, transfer data ms excel ms word ole technology, data entry ms word ms excel, MS word Ms Excel Data enty, data entry, excel sheets, MS word entry, data entry, excel, ppt, ms-word, Data Entry in MS Word-MS Excel, Typing, Article Writiing, Copy Paste, PDF to Word, data entry, ms excel, ms word, data entry ms word or ms excel, offline data entry jobs in MS-word, MS-excel, list the methods that you plan to use to validate collected data from storage devices such as MS Word, MS Excel and emails, with, ms project scheduler job description, big data project manager job description, data project manager job description, how to create a drop down list in excel without data validation, how do i create a drop down list in excel for data entry form, data analytics project manager job description

About the Employer:
( 49 reviews ) Oakville, Canada

Project ID: #32268738

37 freelancers are bidding on average $142 for this job

(1074 Reviews)
8.2
(444 Reviews)
8.3
(547 Reviews)
8.1
(409 Reviews)
8.1
(314 Reviews)
7.4
mrbrave

Hi, I have over 10 years of experience if developing macros for word and excel. I can surely complete the macro within few hours and send you for testing. You will test and see if any change required. So final macro More

$90 USD in 1 day
(289 Reviews)
6.9
(368 Reviews)
6.7
(125 Reviews)
6.7
(130 Reviews)
6.1
(170 Reviews)
6.3
(57 Reviews)
5.2
(28 Reviews)
4.5
zaib14414

Hi I have reviewed the project description of MS Word List creation from a Excel set of data similar to a Direct Mail - Project and I am much confident to complete this task as per your expectations. Let's discuss fur More

$50 USD in 3 days
(6 Reviews)
3.9
Designworld16

hello I read your project description " MS Word List creation from a Excel set of data similar to a Direct Mail - Project" I ensure you that i will do this. if you award me now i can start work Right now and I can del More

$100 USD in 1 day
(10 Reviews)
3.8
AAGGMM

Hello I am Ahmed, I have a very good MS-word skills and more than 7 years experience, and I had achieved many MS-Word projects which involved complex formatting. So, I can achieve this task perfectly without any error More

$100 USD in 1 day
(20 Reviews)
3.7
(10 Reviews)
3.8
(8 Reviews)
2.4
(1 Review)
1.9
sonukumar2803

SONU KUMAR this side, THANKS FOR THIS OPPRTUNITY, I am student and i am expert in re-tying and re-writing the pdf like you job and I will do my work with full enthusiasm and I want to do this work for to be financial More

$200 USD in 7 days
(0 Reviews)
0.0
globalsolution23

"Dear employer, I apply my attention to detail and creativity to every job, large and small. My tools include The Chicago Manual of Style (used by most book publishers) and The Associated Press Stylebook. Of course, y More

$35 USD in 2 days
(0 Reviews)
0.0