copy unick value from sheet 1 and pest it in sheet 2

Hi all
I have prepared one macro to the unique “E/U English”details from Sheet called “DATA”
And pest it in sheet called “End user . Submitter”.
But while I run the macro the formatting is getting hampered in sheet “End user. Submitter”.

Please find the attached file for the same.

Can anybody help me out in this?


Regards
Arindam

Well that all depends. What formatting do you want when the values are copied over?

I will run the macro.
Please run the macro of the attached file then only you will understand the issue.

You are copying one range to a different range which isn't helping.

Will the values on the "End user . Submitter" sheet always exist and then you are going to copy and paste over the top of them?

Yes ,but when i am coping the data it can be more but when i am pestling the data it should be only the unik value so the pest time range will be less na?
is it possible that when I am copying the data then the copy range should be the entire available data of sheet called " DATA " ,column name "E/U English" and when I am pestling the data in next sheet the range should be depend on how many unique value is there.

In that case you could probably just filter for unique values and copy these:

Please Login or Register  to view this content.

Let me know if this works for you.

If it has helped, please consider adding to my reputation by clicking on the star to the left.

Hay Maym Thanks a lot