Macro to copy and paste only unique values from one column to another column in same sheet

**Manish_Gupta** · 05-17-2014, 04:34 PM

Hello Guys,

I need help in creating a Macro which first count the no. of used rows then copies only the unique values present in Column F and paste it into Column G of same sheet.

Please refer the attached Sample sheet for having more clarity.

I want to do this only through a Macro.

Any help will be appreciated.

Thanks,
MG

**RudiS** · 05-17-2014, 05:10 PM

Hi,

I know you asked for a macro, but ultimately formulas are faster and more convenient....
See the proposed solution: 1.jpg

Attached...

**AB33** · 05-18-2014, 04:10 AM

Try the attached code.

**Manish_Gupta** · 05-18-2014, 03:36 PM

Hello AB33,

Many thanks for reply.

The code is working perfect. Only one thing if you can change in it is; the Macro is throwing result in a new sheet and i need the result in the same sheet.

If possible can you please modify the code to show the result in same sheet.

Thanks,
MG

**AB33** · 05-19-2014, 04:38 AM

Amended code!

**Manish_Gupta** · 05-19-2014, 05:44 AM

Hello AB33,

The code is working perfectly fine.

Many thanks for your help.

Thanks,
MG

Macro to copy and paste only unique values from one column to another column in same sheet

LinkBack

Thread Tools

Rate This Thread

Display

Macro to copy and paste only unique values from one column to another column in same sheet

Re: Macro to copy and paste only unique values from one column to another column in same s

Re: Macro to copy and paste only unique values from one column to another column in same s

Re: Macro to copy and paste only unique values from one column to another column in same s

Re: Macro to copy and paste only unique values from one column to another column in same s

Re: Macro to copy and paste only unique values from one column to another column in same s

Thread Information

Users Browsing this Thread

Similar Threads

Macro to copy values from columns of one sheet & paste it to diffrnt Column Sequence

Copy and paste unique values from column, and use countif function to calculate average

Vba - find next empty column, insert column, copy paste values & copy paste formulas

[SOLVED] Macro to identify a unique value in a column to copy and paste value to another sheet

Macro that will copy values in Column J and paste values to Column B in new sheet

Bookmarks

Bookmarks

Posting Permissions