Results 1 to 5 of 5

aSSISTANCE WITH ROW DELETE BASED ON MULTIPLE VLOOPUP CRITERIA FROM ANOTHER WORKBOOK

Threaded View

  1. #1
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,345

    aSSISTANCE WITH ROW DELETE BASED ON MULTIPLE VLOOPUP CRITERIA FROM ANOTHER WORKBOOK

    Hi All

    I have attached a workbook for your perusal. On Sheet 5 there is a button which allows a entry for a row no. When pressed, that row is deleted on Sheet 5. However what I need to accomplish as well is the following:

    At the same time as that rows information is deleted, I need vba code to use vlookup to take information from that row on Sheet 5 and find the duplicate information on Sheet Temp and delete that row on Sheet Temp aswell.

    Is this possible.
    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. assistance with match and rank order formula based on multiple criteria
    By OSepulvedaIII in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2016, 06:21 AM
  2. Replies: 2
    Last Post: 08-31-2015, 03:23 PM
  3. [SOLVED] Index, Match, or VLoopup? Returning a table value based on criteria from two drop down's
    By jkwlvsky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2015, 06:40 PM
  4. [SOLVED] Assistance Needed Identifying Min Values Based On Multiple Criteria
    By elderdane in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 05:00 PM
  5. Multiple VLOOPUP Values and Criteria
    By Thomasdaddy1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2013, 02:20 PM
  6. [SOLVED] Need assistance to sum data based on multiple match criteria
    By consulttk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2012, 12:11 PM
  7. delete multiple row based on criteria
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2009, 05:53 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