+ Reply to Thread
Results 1 to 2 of 2

Overwrite old data and filter using 2 parameters

  1. #1
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Overwrite old data and filter using 2 parameters

    Hi, all

    I have this code in which it will filter based on selection made from drop-down list in Cell K2. At which part I should alter to make the data be filtered by using two parameters instead of one, one from drop-down list in cell K2 and another one from cell M3?

    Please Login or Register  to view this content.
    Hereby I attached an example of the Excel file. Thanks in advance for the help!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: Overwrite old data and filter using 2 parameters

    It's okay, solved it.

    For those who need this, here's the solution. Simply add these lines accordingly in code:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

+ 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. Filter primary pivottable Data Model with parameters from another table
    By George_1990 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2017, 11:01 AM
  2. MACRO to split new data into multiple tabs but not overwrite existing data
    By amo899115 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2016, 01:42 PM
  3. Filter and copy/overwrite to a new workbook and rename to unique filter value
    By gssc141 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2015, 10:28 AM
  4. Filter info by date parameters and populate listbox
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2014, 09:31 AM
  5. [SOLVED] Macro with "save as" --- Need excel to overwrite a file without a prompt to overwrite
    By tsmith1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 10:54 AM
  6. How do I transfer User-Defined filter parameters to then filter another column?
    By fiqulupo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2012, 07:05 PM
  7. Prevent data cell overwrite but allow blank cell overwrite
    By Squasher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2011, 09:24 AM

Tags for this Thread

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