Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2012, 02:46 AM
OTPM OTPM is offline Import Information From Exel to Word Windows 7 32bit Import Information From Exel to Word Office 2010 32bit
Expert
Import Information From Exel to Word
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Import Information From Exel to Word

Hi
I am looking for a way of importing data to a MS Word Form based on the entry in an adjacent cell on the MS Word form. The challenge I have is that I cannot use macros becuase these forms will be integrated into a GP Clinical system and they don't allow macros in MS Word forms. I am looking for an equivalent of VLOOKUP in Excel but in MS Word.

If anyone has any suggestions I would be eternally grateful.

Kind regards



TonyK
Reply With Quote
  #2  
Old 02-15-2012, 10:43 PM
macropod's Avatar
macropod macropod is offline Import Information From Exel to Word Windows 7 64bit Import Information From Exel to Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Tony,

Word has no non-macro facility equivalent to VLOOKUP in Excel. If the values are purely numeric, you could use a formula field (even from outside the table); otherwise, if you're using formfields, you could set the input field's 'calculate on exit' and, possibly, use field coding to achieve the desired result. I'm assuming Excel isn't involved, as nothing in the body of your post suggests anything other than Word table cells are involved.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-16-2012, 01:43 AM
OTPM OTPM is offline Import Information From Exel to Word Windows 7 32bit Import Information From Exel to Word Office 2010 32bit
Expert
Import Information From Exel to Word
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Paul
Many thanks for your response. Unfortunately Excel is involved and there is more text than numbers hence my post.
Kind regards
Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Information From Exel to Word Can Tables or Information be Linked in Word? ddrowe Word 1 11-18-2011 11:50 AM
Import Information From Exel to Word Word Information page rbekel Word 2 04-18-2011 07:01 PM
Import Information From Exel to Word Import pdf pages into MS Word Jonart Word 4 03-31-2011 09:31 AM
Pull Outlook Meeting Information into Word alhare Word 0 02-01-2011 12:51 PM
Recomend a information hiding tool for word 2007 files AlexanderLee Word 0 01-05-2010 01:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft