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
Bookmarks