+ Reply to Thread
Results 1 to 4 of 4

control your sheets data filter with one sheet

  1. #1
    Registered User
    Join Date
    02-17-2019
    Location
    TOUIA
    MS-Off Ver
    2016
    Posts
    4

    control your sheets data filter with one sheet

    Hello Kings of excel

    i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them

    Exemple like in the picture

    M2DFSVV.png

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: control your sheets data filter with one sheet

    OK so what is your question...how to get all data onto 1 sheet?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-17-2019
    Location
    TOUIA
    MS-Off Ver
    2016
    Posts
    4

    Re: control your sheets data filter with one sheet

    yes plz

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: control your sheets data filter with one sheet

    As you have the 2016 version of Excel, perhaps you could use Power Query (Get & Transform) to do what you want. If not it may help if you could upload a sample of a couple of the spreadsheets that you want to combine.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Copy data from one sheet too different new sheets based on a filter
    By BART_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2019, 07:25 AM
  2. [SOLVED] Filter data from one sheet to 14 existing sheets in different workbooks
    By Khalil Handal in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-26-2015, 01:18 PM
  3. Replies: 0
    Last Post: 07-13-2015, 01:19 AM
  4. Replies: 0
    Last Post: 06-20-2015, 02:42 PM
  5. Control filter (drop down list with multiply selection) from a different sheet
    By gowthamj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2014, 01:22 PM
  6. Control filter from somewhere else on the sheet
    By tlacloche in forum Excel General
    Replies: 1
    Last Post: 05-29-2014, 10:34 AM
  7. How to control a Pivot filter from a specific cell on a separate sheet
    By vikash200418 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-23-2013, 03:40 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