View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default linking data to a form

On Thu, 20 Apr 2006 00:21:01 -0700, Nancy
wrote:

I would like to be able to have a link that pulls certain data from each row
into an excel form.
Each of our orders are entered into Excel on seperate rows. Is it possible
to have a link "button" that opens an Excel form with data from a few of the
columns? I do not need to save the forms, just pull up, print and close. I
thought about mail merge, but was hoping for an even more simple solution.



Have you checked out Data--Form from the main menu?

Do this with the active cell anywhere in your table of data.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________