+ Reply to Thread
Results 1 to 2 of 2

How to Remove Duplicates After Each Auto Refresh from External Connection?

  1. 11-10-2012, 09:56 PM #1
    mar0isa
    mar0isa is offline
    Registered User
    Join Date
    11-10-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to Remove Duplicates After Each Auto Refresh from External Connection?

    Does anyone have any suggestions on how to do this better? I am currently running this macro when the data changes. If not, is there a way to specify the sheet without selecting it? In other words, what can I replace ActiveSheet.Range with so I do not have to change to that sheet in the macro? Any help is greatly appreciated as I have searched several hours for this.

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 11-10-2012 at 10:04 PM. Reason: Per forum rules, please use code tags...Thanks.
    Reply With QuoteRegister To Reply
  2. 11-10-2012, 10:31 PM #2
    Moo the Dog
    Moo the Dog is offline
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to Remove Duplicates After Each Auto Refresh from External Connection?

    Would something like this work? 
    Please Login or Register  to view this content.
    -Moo
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1