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:
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!
41 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
"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
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
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
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