#autofilter

  1. K

    How to macro will Unhide all the worksheet except the active sheet

    'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...
    • krunal123
    • Thread
    • #autofilter #condition formatting #excel #formula #confused #excel query #filterwithmultiplecriteria #pivot table#fiilter #repost #vba #copypaste #vba #excel #vba #excel #pleasehelp #vba query #vba tips dynamic vba power automate vba & conditions vba expert vba question
    • Replies: 9
    • Forum: Excel Questions
  2. K

    # Auto filter data According Particular Column base ?????

    ( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"
    • krunal123
    • Thread
    • #autofilter #conditional formatting #easy excel #easyexcel #excel #file error #excel #formula #confused #excel #minimum #index #excel #pivot #excelquery #excelquestion #filter #filterwithmultiplecriteria #if condition #logical #if #excel2016 #pivotable #power query #vba #dates #sumif #vba #excel #if excel & formula
    • Replies: 1
    • Forum: Excel Questions
  3. C

    Autofilter multiple worksheets using text entered in a cell (VBA)

    Hi, I have been struggling with this code for the past couple of days. I am trying to have the user input some text on the "SEARCH" worksheet (Cell A2 in code below) that would automatically filter all other worksheets (10+) for that text and output the results in a "Results" worksheet. For...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top