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!
Bookmarks