Link to home
Start Free TrialLog in
Avatar of brasiman
brasiman

asked on

How to make data entered in an Excel field show up in a specif spot in Word

I have an excel spreadsheet where I have some of my employees put some numbers. I am trying to figure out a way for those number to populate on a Word document. On my spreadsheet, there are multiple fields where we will put numbers. So I am wanting to put each field in Excel into the Word document in a specific place. I am guessing it is done with a macro, but i am not sure how to make it all work. My Office version is 2010. Thanks in advance!!
Avatar of helpfinder
helpfinder
Flag of Slovakia image

You can avoid macro in this case and use Mailing feature in the MS Word. In short you will have excel as database and Word as text editor. In Word you can manage where to put which field (column) values from your database (excel).
For more detailed view please refer to my EE Article
Avatar of brasiman
brasiman

ASKER

Hi helpfinder, thanks for the quick reply!! I will try that now. Thanks!
I tried to make that work but couldn't. So on this spreadsheet, there are multiple areas where i put various numbers. I need those numbers to go onto a Word document automatically. I have seen it done with a macro, will the mail merge work still?
should be.
if you can post a sample of your excel - just a few rows/columns and maybe if you have some Word prepared for this (not necessary) I can try to show you.
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial