+ Reply to Thread
Results 1 to 1 of 1

Programming for Form Letter (Cell Population, New Sheet Population based on Cell Data)

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Saint Louis, MO
    MS-Off Ver
    Excel 2010
    Posts
    12

    Question Programming for Form Letter (Cell Population, New Sheet Population based on Cell Data)

    I'm working on a project for a friend. Essentially what I need this workbook to do it gather information on sheet1 (Info Page) such as name, address, etc.

    I am stuck at two areas:
    1. I need to have a few rows with a drop down box at the beginning of the row specifying a few different options (Options1, Options2, Options3) and depending upon what option is chosen, will ultimately determine what sheet that following data is copied to. If Option1 is chosen and Option1 is linked to Sheet2, then I need the data from Sheet1!A2, Sheet1!A3 to populate on Sheet2!A2, Sheet2!A3. Or if Option2 is chosen and Option2 is linked to Sheet3 I need the data from Sheet1!A2, Sheet1!A3 to populate on Sheet3!A2, Sheet3!A3. What ever data is input of the info page (Sheet1) will need to populate the exact data on the other pages as described above.

    2. Lastly, but not least: I need the ability for IF (for example) Sheet1!A22 has a value that is named "Company", that within the same workbook, it creates a new sheet named "Company" that is a template (a form letter) and within the form letter, it automatically pulls the same data from Sheet1!A22 and puts it within a specific cell on the new "Company" sheet. If for example, Sheet1!A22 never have a value, then a new sheet should never been created.
    If someone is interested in helping me on (what seems to me) this difficult talk, I would be happy to elaborate if needed and be charitable after receiving either the correct instruction or a properly working workbook. I appreciate any and all help!
    Last edited by shelton_4; 07-10-2012 at 08:53 AM. Reason: Change of Title

+ 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