Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2012, 06:37 PM
jclinton jclinton is offline Hyperlink/Data Insert & replace Windows XP Hyperlink/Data Insert & replace Office XP
Novice
Hyperlink/Data Insert & replace
 
Join Date: Sep 2012
Posts: 1
jclinton is on a distinguished road
Question Hyperlink/Data Insert & replace

I have a sheet/template in Word, that on one cell in the table it asks for the employee's start date. That data is located in a different Excel sheet. Is there a way to have a drop-down or just a hyperlink that leads me to the Excel sheet. The user could then click on the correct date cell and word would then input that date into the same cell/table in word?

I am not sure if the makes sense. So it would be like this:



Word Doc:
Employee's start date [Hyperlink]

(The user would click on the hyperlink and it brings them to an excel form that shows Names and start dates. They click on the start date of the correct employee and it places it into the cell)

Word Doc:
Employee's start date [9/7/2004]

Thanks for any assistance,
Jay
Reply With Quote
  #2  
Old 09-19-2012, 07:22 PM
macropod's Avatar
macropod macropod is offline Hyperlink/Data Insert & replace Windows 7 64bit Hyperlink/Data Insert & replace 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 Jay,

In theory, yes, but it would require a fair amount of vba programming and, above all, a means of being able to match the employee completing the document with the records in the workbook.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink/Data Insert & replace Insert text at the end of a sentence Find/Replace AlmostFriday Word 6 06-17-2012 05:21 AM
Hyperlink/Data Insert & replace paste and insert, not replace userman Excel 4 06-06-2012 05:15 AM
How to insert a hyperlink in activex textbox Joe Patrick Word VBA 1 10-03-2011 06:03 AM
Insert Hyperlink - Differing Functionality nell3773 Word 0 04-30-2010 12:23 PM
Find & Replace Insert Issue mipacker Word 0 02-18-2009 08:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


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