Hello all! What a terrific and helpful forum!

I am creating an excel workbook that automates the process of creating a contract. I want my user to number the items in a sequence to include in the contract on sheet1 and on sheet2 I want those items (along with paragraphs of non-changing text) to show up formatted in a formal letter format.

Sheet1 is formatted as a list:

(A) Select B C (D)Description
1 [1,2,3,etc. if selected, 0 if not] "A bunch of stipulations..."
2
3
etc.

Sheet2 is formatted as follows:

Dear "so and so"
Below are the following options that we can present your organization with to make your event.....

INSERT 1
INSERT 2
etc.

Thank you for your interest in....

Signature line.


My issues are:

1. I can get the data to copy over to sheet2 but I can't figure out how to delete the blank lines in between the numbered items so that the contract doesn't have a bunch of blank lines between the items.

NOTE: My list contains 40 items but those 40 items aren't used in each contract, sometimes I will use only 1 item and other times it may be 10-15 items.

To sum this up I need to get data from sheet1 over to sheet2 without leaving a blank line for the items that are not selected this time around.

Any help would be appreciated!

Thanks!
Alan