AUTOFILTER copy and paste

  • Thread starter Thread starter RJ Kelly
  • Start date Start date
R

RJ Kelly

Hi all,

I have a macro that basically filters out duplicate
entries. I would like to know if there is a way to do this:

I have 2 filters set to show me duplicate entries. If I
set a third filter to filter on BLANKS in a certain field
I get the data that I want to delete. Now how can I get
the row numbers of the data that shows up while filtered?
(IE. the blue row numbers ONLY.)

SCENARIO:
I have a HUGE list with many duplicate Customer Numbers.
Most of the people in the list have a FULL RECORD(all
fields have info in them), but when we add another list to
it some of those names do not have data in certain fields,
Those are the records I want to delete the duplicate
entries for. And if I set my filter to one of the "certain
fields" then I can get my list of bad records/duplicate
customer numbers.But I need to know how to only grab the
rows that are "showing" in my filtered state.
thanks for any help in advance....

RJ Kelly
 
Hi,
You can do this simply byu using the Advance filter in excel,- where
you can sort/filter by many things at once, look to help for how to
use

Good luck
Ross
 
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

Best solution to merge multiple Outlook contacts easily 2
Autofilter by combobox selection 1
VBA: How can I use a string variable as autofilter criteria? 4
Problem using Autofilter 1
Autofilter and cell check 1
Filter list in same worksheet issue 3
Resetting autofilters 2
Help with autofilter and filtering a specific column 1

Back
Top