macro to copy unique data from sheet A one column only to sheet B

[JEAN1972]

Hi All

I have a workbook with several worksheets

One sheet named Database contains data from range A1 to AM1 which are headers, data reads actually to 75000 rows.

Looking for macro to copy unique values of Column B1( named supplier ) only of database sheet to another sheet(validation) in same workbook at A1.

[davesexcel]

Very fast

Please Login or Register  to view this content.

[JBeaucaire]

Here is one suggestion:

Please Login or Register  to view this content.

[davesexcel]

Also use advanced filter.

Please Login or Register  to view this content.

[Winon]

I would use:

Please Login or Register  to view this content.

[AB33]

Different approach and much more faster than any loop.

[JEAN1972]

Hello JBeaucaire,davesexcel,Winon

Thanks to the solution, all of them worked marvelously.

Thank you

[JEAN1972]

Different approach and much more faster than any loop.

Hi AB33

Works perfectly but could you adjust to add the supplier header in the macro.
Actually applying macro just give me the unique values but did not insert header Supplier

Thanks for assistance

[AB33]

Here we go!

[Winon]

Thank you for the feedback JEAN1972,

We could use the Code Below:

In which I have applied the KISS principle of keeping it quick and simple.

Please Login or Register  to view this content.

Please see the revised attachment.

Also, thank you for adding to my Reputation, Much appreciated!

Kind Regards.

[JEAN1972]

Thank you for the feedback JEAN1972,

We could use the Code Below:

In which I have applied the KISS principle of keeping it quick and simple.

Please Login or Register  to view this content.

Please see the revised attachment.

Also, thank you for adding to my Reputation, Much appreciated!

Kind Regards.

Thanks Winon

[Winon]

You are welcome JEAN1972,

Glad I could help.

Also, thank you for adding to my Reputation, Much appreciated!

Kind Regards.