I need data from an excel sheet migrating to a word document in a specific format
- or -
Post a project like this2428
$
- Posted:
- Proposals: 1
- Remote
- #1662250
- Awarded
Description
Experience Level: Entry
Estimated project duration: less than 1 week
I have a diary in an exported excel format the requires converting into a specific format in word.
Attached is:
1. Excel document FROM which the correct data is to be pulled from
2. Word document meeting dates a4.docx - with last years diary in A4 format. 1st September 2017 to 31st December 2017 is a complete copy of last years.So that is 1/3 of the job done!!
3. Word document - meeting diary A5 - This file represents the correct format and styling required for the final document. Unfortunately there are a lot of glitches with layout throughout the document otherwise this could be used as the starting point and just amend the data according to the excel file
Next, by checking the excel output you will see that other than one day or maybe one week change from last year, the meetings are the same!
So last year if you look in the word doc
Tuesday, Jan 3 2017
Holmes 4656 LE
Argonauts 8210 LE
Sir John Babington KT 410 LO
Now look at the spreadsheet and you will see that these 3 are now on Tuesday 2nd Jan 2018
The margins and other design elements are confirmed below:
A5 page with an 8mm top margin, 10mm bottom and 12.5mm at the sides.
The font is Times New Roman body text is 6.97pt (7pt) with 10.97pt (11pt) page headers.
Two columns apart from title on first page. Each date should finish cleaning on each page.
This should be sufficient information to complete the task but any queries please send message
Attached is:
1. Excel document FROM which the correct data is to be pulled from
2. Word document meeting dates a4.docx - with last years diary in A4 format. 1st September 2017 to 31st December 2017 is a complete copy of last years.So that is 1/3 of the job done!!
3. Word document - meeting diary A5 - This file represents the correct format and styling required for the final document. Unfortunately there are a lot of glitches with layout throughout the document otherwise this could be used as the starting point and just amend the data according to the excel file
Next, by checking the excel output you will see that other than one day or maybe one week change from last year, the meetings are the same!
So last year if you look in the word doc
Tuesday, Jan 3 2017
Holmes 4656 LE
Argonauts 8210 LE
Sir John Babington KT 410 LO
Now look at the spreadsheet and you will see that these 3 are now on Tuesday 2nd Jan 2018
The margins and other design elements are confirmed below:
A5 page with an 8mm top margin, 10mm bottom and 12.5mm at the sides.
The font is Times New Roman body text is 6.97pt (7pt) with 10.97pt (11pt) page headers.
Two columns apart from title on first page. Each date should finish cleaning on each page.
This should be sufficient information to complete the task but any queries please send message
Projects Completed
102
Freelancers worked with
54
Projects awarded
38%
Last project
17 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies