Find Jobs
Hire Freelancers

Populate fields in Word and Excel documents using master Excel list

$250-750 AUD

Selesai
Dibuat hampir 9 tahun yang lalu

$250-750 AUD

Dibayar ketika dikirim
We have a series of approximately ten MS Word documents and excel documents that must be populated with approximately eight variables relating to a job. The information is normally in a table at the start of the document and will include items such as the job number, customer name, product type etc. The documents may include a cover page with some of the information on there too. Currently we have to manually enter all of the information which leads to wasted time and errors. We would like to have a master list in excel into which all of the information can be entered. This information should then be used to populate a series of MS Word ans Excel templates which can then be saved into the correct folder on the server and completed as required. It would be preferable for each line in the excel list to have a button that can be pressed to "generate documents". When the user clicks the button, he should be presented with a dialogue box asking where the files should be saved. When he clicks "save" the documents are populated with the information and saved into the selected folder with the job number as a prefix on the file name. I have attached a sample of the information list along with an example of the typical target document layout. The successful bidder must have told me about similar projects they have worked on in the past and be able to demonstrate that they have read this brief. To be considered for this work you must state what day of the week it is that you have entered your bid.
ID Proyek: 8030188

Tentang proyek

34 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
Hi Sir. I am bidding on Thursday. I can embed the button in Excel sheet against each row to populate document with corresponding data but instead of embedding button in every row of Excel, I can improve the design by developing a user interface which shall present you with all the data and pressing the button after selecting a row will move that row's data to Word doc. I have been doing similar work before. Please discuss and I shall share a sample for your analysis before awarding the project. Thank you. Usman
$310 AUD dalam 2 hari
5,0 (55 ulasan)
6,3
6,3
34 freelancer menawar dengan rata-rata $363 AUD untuk pekerjaan ini
Avatar Pengguna
Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation
$631 AUD dalam 6 hari
4,9 (285 ulasan)
7,4
7,4
Avatar Pengguna
Hi, I'd be happy to help you with this project. You can visit my profile page to see some of the my completed projects as well as the feedback that clients have left me It is Wednesday evening here in California
$350 AUD dalam 3 hari
4,9 (187 ulasan)
7,1
7,1
Avatar Pengguna
Hi, Its Thursday out here in India. I am an Excel macro expert with prior experience in automation of Excel based projects involving export to Word documents. I can provide screenshots of previous work for your reference. From the files provided, the word document contains a) Formatted text b) Tables with data c) Images Its important for me to know the Excel/Word version in use at the outset since there can be interoperability issues. Let me know and we can discuss. Cheers, Arul
$450 AUD dalam 4 hari
5,0 (147 ulasan)
6,5
6,5
Avatar Pengguna
Thursday Hi, I clearly understand the project requirement and get you the spreadsheet with macro which would generate doc file based master spreadsheet. Looking forward to work with you Regards FINGERRPRINT
$526 AUD dalam 7 hari
4,8 (104 ulasan)
6,8
6,8
Avatar Pengguna
Thursday Hi, I am Nallakumar. I have more than 8 years of experience in Office Automation. For this, we can have Word templates with Bookmarks on the locations where we have to insert the data and Excel templates, that will have named cells or with cell address. This will help in easy maintenance also, as you can change the details later, just by adding the reference in this sheet, without changing the code. In the the Master excel we will have a settings sheet, that will relate the Bookmark/cell address with the fields to be filled from the Master sheet. In the main sheet we will have a combo box to select the job to which the documents needs to be created. Other than the above we can add the functionality you have given to make the application more simple to use and maintain. Thanks, Nalla
$705 AUD dalam 2 hari
5,0 (5 ulasan)
6,0
6,0
Avatar Pengguna
Here in Argentina it's still Wednesday. Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. I currently have a macro that does the job you want, at least the part more complex, autopopulate Word files, the Excel part is much simpler. That macro i have used in several projects here in Freelancer. Check my reviews. They speak for themselves. Best regards
$555 AUD dalam 5 hari
5,0 (57 ulasan)
5,5
5,5
Avatar Pengguna
Hi there, I'm expert in Advance Excel and Word. I can do this. Please check my feedback as I've done several job in freelancer. I'm ready to start immediately. Please PM me. Thank you, FARZANA PINKY.
$250 AUD dalam 3 hari
4,8 (78 ulasan)
5,9
5,9
Avatar Pengguna
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$295 AUD dalam 6 hari
4,9 (50 ulasan)
5,4
5,4
Avatar Pengguna
Hello sir, i read your requirements very-well and ready to start work from now. Hope you will give me a chance to do work with you, waiting for your reply, Thank you
$526 AUD dalam 5 hari
5,0 (6 ulasan)
5,0
5,0
Avatar Pengguna
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 and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$333 AUD dalam 7 hari
4,5 (38 ulasan)
5,5
5,5
Avatar Pengguna
Thursday Having more than 11 years of experience in banking /finance /accounting, business analysis, Data analysis, process re-engineering, copy typing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes complex Formulae, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills.
$250 AUD dalam 2 hari
5,0 (21 ulasan)
4,5
4,5
Avatar Pengguna
i have some custome tools so it become easy and fast to complete this job as soon as possible .i am highly interested to do this .give me permision to complete this .waiting for your response thank youn
$250 AUD dalam 3 hari
5,0 (13 ulasan)
3,9
3,9
Avatar Pengguna
Thursday Hello Sir/Madam,i am ready to start your job as per your requirement Thanks this great opportunity,if you like than we can discuss further, awaiting for your positive response.I have been working in the field of Data-Entry,Excel,Web Search,Web scraping,Leads,Data Processing etc job from the last 4 years. I am good fit for your projects as i always be sincere with my clients and with my work. I aim to bring a modern but experienced approach to your projects. Allow me to provide you good services based on my experience and bring you vision to life looking forward to hear from you. Thanks
$250 AUD dalam 3 hari
3,5 (34 ulasan)
4,7
4,7
Avatar Pengguna
I am an advanced user with over 10 years of MS Office experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft problem, formula(s), or task.I am looking forward to help you achieve your office goals. and I am ready to start your project
$250 AUD dalam 4 hari
5,0 (7 ulasan)
3,5
3,5
Avatar Pengguna
hi this Thursday I am bidding on this project. I have already done similar project for an AUD client. i can complete this project quickly using mail merge and macro . I can create a template as shown on the attached image . I can create a master file with all required fields and from there I can link the master spreadsheet with the concept of mail merge in word . so you can automatically get separate template as attached image for each row record in master file spreadsheet.
$250 AUD dalam 2 hari
4,6 (15 ulasan)
3,9
3,9
Avatar Pengguna
A proposal has not yet been provided
$255 AUD dalam 4 hari
4,8 (3 ulasan)
1,8
1,8
Avatar Pengguna
Hi, Nice to meet you Let me introduce my self. My name is novtrian from Indonesia. I can help you with professional result, satisfaction guarantee, and give you lowest price to get my first project in freelancer.com and increase my reputation. Very easy project. We can use macro to generate the ms word/pdf document. as simply as click the button. i can show the preview with video screen capture. macros script can be deliver by email I will happy to discuss further. Regards Novtrian
$250 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$277 AUD dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Good Day. i am a knowledgeable in ms word and ms excel applications so that i can handle this project you post in 10 days.. i hope you consider my bid. thank you.
$555 AUD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I will be able to turn this job around very quickly. I work in excel and word (and SAP) on a daily basis and will have no problem creating a spreadsheet that will populate other excel and word documents to be saved in a separate location. I am placing my bid for this work on Wednesday, July 8th.
$300 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
Wangara, Australia
5,0
25
Memverifikasi Metode pembayaran
Anggota sejak Feb 27, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.