I have created a macro to copy subsets of data to a new workbook by filtering the main set of data. It would appreciated if someone would provide me with code to select only the cells with data(in the new workbook) so I can copy that data to another sheet. Currently the copy procedure copies all the rows in the sheet, including the blank rows which recreates a huge file. Thank you in advance for any assistance you may provide.