Copy & Paste Columns to Specific Range while Removing Blanks & Duplicates

Sintek,

Sorry about that. It's a learning curve for me. They've been edited.

the name of the worksheet is Folder Generator

All information is on the same worksheet. There's values from S:AV that needs to be copied and pasted to another section, which I have set a range called Panels. The problem with my original code was that:

1) the paste went beyond the specified range "Panels". For example it pasted into the Panels range and one column to the right. Then it pasted many blank rows below and outside of the "Panels" range. I would like the information to be contained in the "Panels" range, which is AZ95:BM104 respectively.
2) It contained duplicated values, which I would like to remove, if possible.

Originally Posted by dondada82

Please Login or Register  to view this content.

Your code is confusing, better upload a small sample workbook with before/after.

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.

I think some information is still missing about "many blanks", "duplicates" etc and how you want the result.

to upload a workbook,

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

The file should be here now. Thanks again for all your help.

Thanks for the workook.

I can see many blanks, but no duplicates...

You have 30 columns 100 rows to copy, S2:AV100, and only 10 rows 14 columns in "Panels" named range.
How do you want the result?

Can you upload a sample data and the result clearly showing the logic behind it?

If you populate the folder with engine 1 inspection (A2) and hit the update package button, then hit the update panels button (with my original coding) it inputs the information in the "Panels" range as first row 432AT, 432AT, 432AT, etc...... and second row as 443AB, 443AB, 443AB, etc.....

I would like it to remove the duplicates and just see one set of 432AT and 433AB and no blank cells.

Still not clear to me though...

Please Login or Register  to view this content.

Jindon,

That looks like it's working as it should. Many thanks.

Glad that was what you wanted and thanks for the rep.

If you want to stop when data to be pasted exceeds the number of cells in "Panels" then add 2 lines.

Please Login or Register  to view this content.

Jindon,

Thanks again. I went to get some sleep since it after 6am my time. So everything works perfectly. I filled some of the columns with erroneous data to see if it stayed within the "Panels" range and it did. I'll add the two lines above, although I may never need it. Thanks again!