Concluído

Excel to Word Macro

Hi there Excel and Word Power Users!

I would like to have someone write me a macro that I can use in Excel. See the two files attached.

Users will fill out the Excel Template. They will enter in the Value and Headers Columns. They can enter up to 26 row in a single File Number. There can be up to 10 File Numbers.

On a button push from Excel, the data in the Green and Yellow cells will be copies to the Word document. The File Number (Red Highlight with White Letter) and the Value and Header Number (Dark Green with White Letter) will be updated for each entry.

Note, the Syntax in the Word document is very important. For example, it must be:

File_#_Headers(#) = "..."

File_#_Values(#) = $...

If it is:

File_#_Headers(#)="..."

File_#_Values(#)=$...

Then it won't work. The syntax needs to be exactly what is in the word document.

I would prefer if the cell was empty in Excel, that I wouldn't have that entry in Word. However, if that is too hard, I can always just delete the unused cells.

Only serious responses please. Please include "Water is wet" in your response so I know you have read this far in the message.

All the best!

Brock

Habilidades: Processamento de Dados, Processamento de dados, Excel, Visual Basic, Word

Veja mais: create word document from excel vba, link data from excel to word, generate word document from excel data, generate word document from excel macro, macro to export data from excel to word, populate word document from excel vba, how do i merge excel data into word document?, how to merge excel data into a word document, vba word macro refrence excel range, excel vba com send parameter word macro, vba open close excel workbook word macro, vba excel word macro, word macro create excel sheet, excel word macro examples, create excel word macro, word macro read excel, word macro excel based styles, convert word macro excel, word macro create excel file, creating word macro document excel

Acerca do Empregador:
( 4 comentários ) Salt Lake City, United States

ID do Projeto: #19020790

Concedido a:

MimiFL

Hello, lets first start with "Water is wet" which was required. Ok, that being said i believe i can help you. I've done many Excel to Word automation without any problems. If you are interested in working with me, plea Mais

$61 USD em 0 dias
(469 Comentários)
6.9

41 freelancers estão ofertando em média $96 para esse trabalho

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Mais

$200 USD in 2 dias
(696 Comentários)
8.4
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. Mais

$180 USD in 3 dias
(332 Comentários)
7.9
zekovicm

Hi there,I am Excel Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within th Mais

$155 USD in 3 dias
(123 Comentários)
7.2
paris2785

Water is wet. Hi, Brock! 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 Excel application that will generate a Word template based on Mais

$140 USD in 2 dias
(203 Comentários)
7.2
elqueabandona

Hello Brock, "Water is wet", 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. Check my reviews, they speak for th Mais

$200 USD in 7 dias
(225 Comentários)
6.9
TonmoyRoy111

"Water is wet" Dear client I understand the scope of work completely. I can write the macro code for you which will solve the purpose. Kindly contact me. Roy

$100 USD in 2 dias
(311 Comentários)
6.7
ksriniravi

Water is wet! Greetings! I have reviewed the 2 attachments and I can come up with a macro for your requirement (including "I would prefer if the cell was empty in Excel, that I wouldn't have that entry in Word. " Mais

$50 USD em 1 dia
(182 Comentários)
6.8
diorisaguilar

Hi there, it's an interesting project. It can be done with a macro in Excel (VBA) using a button that can be placed in the ribbon of the Excel application or in the spreadsheet. Once clicked it will create a new Word d Mais

$80 USD in 2 dias
(41 Comentários)
6.0
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel

$98 USD in 3 dias
(103 Comentários)
6.2
lightingdavid

Hello. I have good skills in "Data Entry, Data Processing, Excel, Visual Basic, Word". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefull Mais

$140 USD em 1 dia
(51 Comentários)
5.6
helalru

Dear sir, I have read your project details and understand.I am a responsible and dynamic person with a strong sense of commitment; giving the best of my skills and experience to get the job done. here I am running a t Mais

$30 USD in 3 dias
(40 Comentários)
5.5
beltran0404

Water is wet Hello, I am Luis and I will be glad to assist you with this project. I can work with Excel to Word linking. Please contact me by chat then we could discuss further details, Luis Romero

$70 USD in 5 dias
(133 Comentários)
5.5
vsprybhanu

"Water is wet" Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Mais

$120 USD in 3 dias
(81 Comentários)
5.5
nvchien94

Hello there. Water is wet. I am an Excel VBA coder and I did some project same with your requirement in past. and I can modify it to match your requirement. It’s not hard and will fast. Please contact me and I will do Mais

$50 USD em 1 dia
(60 Comentários)
4.7
Sercho56

I have extensive experience in writing VBA code within the full Microsoft Office suite. I will be able to write you this Macro within the day. I completely understand your logic and have examined the files. You will Mais

$50 USD in 2 dias
(10 Comentários)
4.5
nelumindralal

Water is wet Hi, I went thru the description This project can be done Send me msg in the chat, then we can discuss more on it I look forward to hearing from you Thanks regards Thushara

$100 USD in 3 dias
(28 Comentários)
4.4
rIbrarahmed

hi, Water is wet I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. Mais

$122 USD em 1 dia
(20 Comentários)
4.4
nbprince

Hi dear employer, yes I am expert in Excel and its macros. I had already done many excel jobs and ready to do it as well.

$60 USD in 3 dias
(17 Comentários)
3.9
srijanagrawal21

Hello, Hope you are doing well. WATER IS WET I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMU Mais

$60 USD in 3 dias
(21 Comentários)
3.7
gsanggara

"Water is wet" Dear Brock Emerson, My name is Garbo, Excel automation freelancer. I am very interested to work on your project I know advance excel very well, hard worker and focus on details person, sure will Mais

$100 USD em 1 dia
(23 Comentários)
3.8