+ Reply to Thread
Results 1 to 2 of 2

Creating a Function

  1. #1
    Registered User
    Join Date
    03-11-2007
    Posts
    1

    Question Creating a Function

    Here's my scenario:
    I am creating documents on multiple worksheets in a workbook. Info on the documents will be changed for each client then the workbook will be "saved as" for each client (maybe I should have made the original docs as templates?). My problem right now is that one of the docs is Terms and Conditions for a Caterer. The last page of the doc needs to have the caterer's name, address, phone, fax, email and website info inserted. The person filling out the doc will have to choose from a list of 10 caterers. Instead of manually entering that info each time, I thought it would be easier to have one of the worksheets be some kind of database of all the caterers, so that a simple keystroke in the cell on the doc would call up the caterer's info from the database. I am not experienced in macros or arrays etc., so if you can help me, I need instructions in layman's terms. Thanks in advance.
    --Kim

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    here is an example - not sure if this is what you want.
    Sheet1 contains the vendor names, addresses, etc by columns (say a1 through e1 for a vendor, with more vendors in rows 2 and down
    so myname is the vendors name and gets put in sheet2 cell A1
    and myadd is the vendors address and gets put in sheet2 cell A2

    Before running the maco, cimply select (click on) the vendor name that you want to use

    If you need to specify which sheet to put the info on, please advise. The location of where the info is put can also easily be changed
    Please Login or Register  to view this content.
    Last edited by VBA Noob; 03-11-2007 at 01:58 PM.
    not a professional, just trying to assist.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1