Excel to Word Macro

已完成 已发布的 5 年前 货到付款
已完成 货到付款

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

数据输入 数据处理 Excel Visual Basic Word

项目ID: #19020790

关于项目

37个方案 远程项目 活跃的5 年前

授予:

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 更多

$61 USD 在0天内
(512条评论)
7.0

有37名威客正在参与此工作的竞标,均价$93/小时

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. 更多

$180 USD 在3天内
(344条评论)
8.0
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 更多

$155 USD 在3天内
(137条评论)
7.4
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 更多

$140 USD 在2天内
(235条评论)
7.4
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. " 更多

$50USD 在1天里
(193条评论)
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 在2天内
(341条评论)
6.9
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 更多

$200 USD 在7天内
(235条评论)
6.9
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 更多

$80 USD 在2天内
(48条评论)
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 更多

$140USD 在1天里
(100条评论)
5.9
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 更多

$50USD 在1天里
(139条评论)
5.9
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 在5天内
(153条评论)
5.7
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 在3天内
(103条评论)
6.2
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 更多

$120 USD 在3天内
(92条评论)
5.7
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. 更多

$122USD 在1天里
(26条评论)
4.8
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 更多

$50 USD 在2天内
(13条评论)
4.7
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 在3天内
(29条评论)
4.4
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 更多

$100USD 在1天里
(27条评论)
4.2
maguirrer

Hello, I can help you with this project, please send me a message so I can start working on it inmediately, and send you back as soon as possible

$42 USD 在2天内
(26条评论)
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 更多

$60 USD 在3天内
(25条评论)
3.9
ielucerotrad1

"Water is wet". I can do the job! I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project 更多

$45 USD 在3天内
(15条评论)
3.9
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 在3天内
(24条评论)
4.1