WILL COMPENSATE FOR PROPERLY WORKING WORKBOOK.

To start off, the workbook with have 4 sheets in as soon as its opened (Sheet1, Sheet2, Sheet3, Sheet 4)

Sheet1 will be where data is input. For example, rows 20 through 30 will be a place to put data.
  • A20 through A30 will be where an Account Owner's name will be listed.
  • B20 through B30 will be the Account Owner's address.
  • C20 through C30 will be the Account Owner's account number.
  • E20 through E30 will be a drop down menu with three options. Explained below.

Each time that an Account Owner's name is entered into A20 through A30, it should create a new sheet in the same workbook with the tab named the same as the cell it is created from. Each time that one of these new sheets are created, it should be created off of a template that already has a form letter within it.

For Example:

If I entered the following:

A......................B................................................C...................E......
20 Doe LLC........123 Main St, Anytown USA 12345.....40929402.......Business Account
21 Smith LLC......450 West St, Anytown USA 12345....40492848........Consumer Account
22 Bush LLC.......215 Day St, Anytown USA 12345,.....40294925.......Government Account

It should create three new worksheets named: Doe LLC; Smith LLC; Bush LLC. Lets talk about Doe LLC as example. When the Doe LLC worksheet is created, it should automatically copy A20, B20, C20 and D20 to the "Doe LLC" sheet into A1, B1, C1, E1 respectively. This new worksheet should already have form data in it when it is created. It should look like this:


(Doe LLC will be the recipient in this instance)(Bold is template form data that should pre-exist when new sheet is created) The senders name and address will =A1, =A2 and need to be predefined in template.
----------------------------------------------------------------------------
Doe LLC
123 Main Street, Anytown USA 12345

Senders Name
Senders Address

Account Number: 012345679

Re: Please Review Your Account for Changes

To Whom It May Concern:

This is a form letter that will automatically be populated as soon as a new sheet
is created.

Regards,
Senders Name

----------------------------------------------------------------------------

As far as the other 3 sheets that I was talking about when the workbook is opened, those three sheets will be Business Account, Consumer Account and Government Account and when selecting such an option from the drop down menus in E20 through E30, it should also copy that entire row of data into whichever account has been selected from the drop down menu into its respective worksheet.

I know this is kind of complex; at least for someone who doesn't do VBA. But I will help as much as possible and am available to chat. Will compensate for time.