Search feature

  • Thread starter Thread starter Merie
  • Start date Start date
M

Merie

Hello everyone,

I am very new to VBA. Is it possible to program a command button t
perform a "search" within a worksheet, and then create a new workshee
where the search can "dump" duplicates? I have a running list of abou
500 entries (and growing by the minute) and am trying to avoi
duplicates.

Thanks for all your help. You guys rock
 
Hi
try using 'Data - Filter - Advanced Filter' and check 'Unique entries'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

for every cell search identical in range, not whole column; how? 2
Macro to rearrange/add columns based on column header? 2
Data copy from a seperate sheet to data sheet 1
Searching for a string and then performing an action if present 1
Searching for Duplicates across columns and print to new column 1
Append One Array to Another, and Consolidate 47
Finding Duplicate Entries - Saving Worksheet if none found 3
Excel VBA 1

Back
Top