unable to retrieve data

NoSparks · #9 02-27-2018, 08:34 AM

No cells in column A contain OFM and KH.
I suspect the filter operator should be xlOR,
and you've changed things from the original file displaying rows where A is not OFM to displaying rows where A is OFM,
and neither line displayed after filtering for OFM or KH has Collar & Cuff in column M.

So, I'm not sure what it is you want the filters to do, can you put into words, what should be displayed on screen after the filters have been applied.

Quote:

and whenever i click on the button it would paste the same row again.
it there a way for it to not have duplicate?

Excel has a built in Remove Duplicates function on the Data Ribbon in the Data Tools section.

Also, please alter the clear what's left section of code to be

Code:

        ' clear what's left
        On Error Resume Next   'suppress error notification in case nothing visible
        .Offset(1).SpecialCells(xlCellTypeVisible).ClearContents
        On Error GoTo 0         'remove suppression of error notification

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"word was unable to open the data source" error	meganadand	Mail Merge	6	02-27-2020 11:25 AM
Retrieve the last activated document name.	eduzs	Word VBA	1	08-22-2017 03:11 PM
Unable to open Outlook, receiving message unable to open because (myaccount)@gmail.c	Flyin' Aces Tattoo	Outlook	0	04-20-2013 11:56 AM
Retrieve PPS files	uncledewey	PowerPoint	2	08-10-2012 09:08 AM
Microsoft Scheduler retrieve Calendar data	badda	Office	0	11-22-2009 06:04 AM