+ Reply to Thread
Results 1 to 4 of 4

Search Invoice No quickly and highlight

  1. #1
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    499

    Search Invoice No quickly and highlight

    Hi all,
    i have a problem in search invoice no by filter quickly. in this i have to search sheet1 all invoices from 18-19-DATA sheet. can any body tell me how quickly i can do it? using filter, how i enter all invoices or search quickly and highlight.
    if it is possible to search and only desired invoices and hide all other invoices.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,488

    Re: Search Invoice No quickly and highlight

    Personally I'd use a Pivot table with a Slicer for selecting the Inv. No.

    See attached
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    499

    Re: Search Invoice No quickly and highlight

    hi richard,
    in this file, i want copy all search invoices at once then paste another file. slicer will be searched one by one. do you have any short cut?

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,488

    Re: Search Invoice No quickly and highlight

    You can multiselect with the slicer.

    Otherwise use an Advanced Data Filter and a criteria range.

+ 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] Mid,Find,Search Function to Pull out an Invoice Number w/in Inconsistent Format
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2018, 11:41 AM
  2. Able to quickly search/tag cells that contain any of a few phrases?
    By nscarritt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2017, 11:38 AM
  3. [SOLVED] Search number quickly
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-28-2013, 09:01 PM
  4. User Search Form update Records using Invoice Number
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2013, 04:31 PM
  5. highlight passed due invoice dates
    By Loveabull in forum Excel General
    Replies: 1
    Last Post: 02-18-2013, 02:02 PM
  6. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  7. Search and highlight
    By malo1066 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2012, 11:42 PM

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