+ Reply to Thread
Results 1 to 2 of 2

Search Multiple tables on multiple worksheets - find next/ previous item.

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    York, England
    MS-Off Ver
    Excel 365
    Posts
    8

    Search Multiple tables on multiple worksheets - find next/ previous item.

    Morning All,


    I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it, please see attached as trying to wrap in CODE tags I get a SQL error.


    This works well when searching by Opportunity Name as this is a unique value. However, when searching by Client there could be multiple results so I need a way of moving to the next or previous record (Just in case the user gets click happy). To facilitate this, I have included a Next and Previous button on the search form - I'm just not sure how to code the functions to get them to work, or if I need to change my main search code above to get this all to work.

    So any help you can give would be greatly appreciated as this is the last piece of the puzzle to get my Userform up and running.

    For clarity, I have also posted this on Mr Excel (I cannot include the link, as I get the following error: You are not allowed to post any kinds of links, images or videos until you post a few times. )

    However, it's been 5 days without a reply, so I though it would be OK to post here, to see if there's any response.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,448

    Re: Search Multiple tables on multiple worksheets - find next/ previous item.

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Replies: 1
    Last Post: 10-30-2018, 07:38 PM
  2. Replies: 5
    Last Post: 03-01-2017, 05:41 PM
  3. Code adding rows to multiple tables in multiple worksheets
    By gabriel78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2017, 05:26 AM
  4. Search for item across multiple sheets with multiple answers
    By tmg148 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-23-2013, 08:56 PM
  5. Taking the next item in a list into 1 of 2 tables based on the previous item time
    By SoleAris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:59 PM
  6. Applying filters to multiple pivot tables across multiple worksheets
    By gbarragan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2010, 12:05 PM
  7. Find(search) value from multiple worksheets and display it in labelbox
    By gandrinno in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-14-2009, 05:05 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