for some odd reason the attachments link in this forum isn't working.

This is what I'm trying to do:

I have a worksheet (Folder Generator) that I created in excel that gets populated from other worksheets within the document. At any given moment when I up the the Folder Generator with new information columns S:AV information can change, but the values within these columns will never be full and many blanks will be portrayed. Some of the values within these column can also be duplicated, which I would like to have it delete all duplicated values (but I need at least one of the duplicated values to stay).

My original code copied and special pasted values only from S2:AV100 (values will never grow more than that range) into the "Panels" range, which starts at $AZ$95 and ends at $BM$104.

The copy and paste feature works, but its pasting some of the information outside of the "Panels" range and filling all empty rows with blanks. I know this because I have borders that disappear as soon as I update the values in the "Panels" range.

I hope my explanation is straight forward and doesn't add more confusion. I do apologize in advance.