Results 1 to 15 of 15

A macro wich will delete (or hide) rows in one tab under conditions from other tab

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2020
    Location
    Warsaw, Poland
    MS-Off Ver
    365
    Posts
    28

    A macro wich will delete (or hide) rows in one tab under conditions from other tab

    Hi guys, as I'm not really familiar with VBA, this is really hard for me to figure out how to write macro.

    I already have a macro, which I need to change (or to just have new one), because need to change the process. What I have Is a button, which delete rows with name "invoice" in specific column.

    What I need right now (as I needed to make some changes in the tab 1) is a macro which automatically will remove/hide rows from tab 1. The difference now is that I need to follow what is in Column A, Sheet1 - not all invoices must be deleted. Sometimes I would need to delete Black, sometimes Red, and sometimes both. So I was thinking of having combo box instead of a button, but have no clue how to do this. I already made a new list (old was just "invoice" or "non-invoice") and put a combo box. But tried to change macro I already have and did not work.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA/Macro - Delete rows if 2 conditions are met
    By Nikhil76 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-19-2018, 03:18 AM
  2. [SOLVED] Need a macro to delete rows based on multiple conditions
    By WorkAccount2 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-30-2017, 12:33 PM
  3. Macro to Hide or Delete Rows is not Consistance -- Please help
    By sspiel4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2016, 04:32 PM
  4. [SOLVED] Macro to Delete Rows based on Specific Conditions
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 05:29 PM
  5. Macro to delete rows with conditions
    By adray13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2012, 11:05 AM
  6. [SOLVED] Macro required to delete rows with multiple conditions
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2012, 03:53 AM
  7. macro to delete (not hide) rows and resort
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2009, 06:09 PM

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