+ Reply to Thread
Results 1 to 2 of 2

Vba duplicate entries are not showing in navigation

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    Vba duplicate entries are not showing in navigation

    I would like to see all the records by using navigation button. Duplicate entries are not showing. For example repeated name in the column not moving next record by clicking arrow button. Pfa the sample file. And also i would like to see the filtered record by using navigation button
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Vba duplicate entries are not showing in navigation

    It's because you're using the Find function, which does a new search each time starting from the first cell (by default) and keeps finding the first occurrence, which you've already found - hence you're not progressing beyond that first occurrence. Have a look at the "After:=" parameter in the find function. If that puts you on the right track and you can modify it from here, let me know otherwise I'll fix it for you ...

    PS - you might want to note that a shortening of Assistant Manager in English should not be *** Manager! Try Asst Manager :-)
    Last edited by MatrixMan; 02-27-2017 at 01:28 PM.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to get reference of duplicate value and set remove duplicate value for future entries
    By bala04msw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2016, 08:13 AM
  2. Replies: 2
    Last Post: 03-05-2015, 04:10 PM
  3. Replies: 0
    Last Post: 06-14-2012, 12:38 PM
  4. Duplicate Entries into List of Unique Entries
    By MjRmatt in forum Excel General
    Replies: 1
    Last Post: 08-18-2010, 11:53 AM
  5. Help showing date/time between entries
    By Ricdic in forum Excel General
    Replies: 2
    Last Post: 10-11-2008, 09:35 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1