Results 1 to 3 of 3

Filter data from one sheet to another

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    MEXICO
    MS-Off Ver
    365
    Posts
    3

    Filter data from one sheet to another

    Hello Everyone!

    I need help filtering data from one sheet to another using macros and advanced filtering. I am new using macros, and I would really aprecciate if you could help me.
    The idea goes as follow:
    I got a worksheet called "Promos" that contains a table full of data. I got another worksheet called "Resume ". The idea would be filtering the data from a list located in Resume, and just pressing a botton to update the filter in PROMOS.

    Let me know if you need more information to undestand the situation.

    Thank you very much!!

    Additional info: I attach a small example, I would like to select a name and FY in the list located in Resume, but I dont want the data to be pasted in Resume I just want the original table in the sheet Promos to be updated.

    This is what I have been trying to do with the recorder.
    Sub Macro1()
    '
    ' Macro1 Macro
    '

    '
    Application.CutCopyMode = False
    Application.CutCopyMode = False
    Application.CutCopyMode = False
    Application.CutCopyMode = False
    Range("E3:AB1523").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
    Sheets("Resumen Q2 FY20").Range("O4:O5"), Unique:=False
    ActiveWindow.SmallScroll Down:=-367
    End Sub

    The problem with this macro is that it filters the data in the sheet Resume and not the sheet with the original table.
    Attached Files Attached Files
    Last edited by Reyzenamv; 01-26-2021 at 02:55 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter data on sheet1 and show visible filter data on sheet 2 in colmn A
    By TAMMY32 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-25-2021, 09:35 PM
  2. Copy Data from current sheet with Auto Filter/Looping then paste to another sheet
    By stepkwan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2020, 09:04 AM
  3. Replies: 2
    Last Post: 05-31-2016, 01:55 PM
  4. Filter sheet data with ComboBoxes, then Update UserForm with filtered sheet data
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2015, 05:59 AM
  5. Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  6. Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data
    By santhoshjoseph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 07:07 AM
  7. Filter, copy filtered data into another sheet, create a file of that sheet..
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-17-2012, 02:26 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