Example. I would like to take data from one sheet (if it is selected) and populate it to another sheet in the workbook, in consecutive row without the spacing of the first sheet. For example. Sheet 1, Rows 2, 9, 31, if selected I would populate to sheet 2, as Rows 1, 2, 3 in order. Basically I am selecting names from a list on sheet 1 and would like to post them on sheet two as the "selected recipents". I want them to populate without all of the extra spaces. Does anyone have any suggestions they might offer. Thanks for any help....