+ Reply to Thread
Results 1 to 3 of 3

VBA To search for Cell Value on a different sheet and delete entire row

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    VBA To search for Cell Value on a different sheet and delete entire row

    Hi all I am new to the forum, and fairly new to VBA so still finding my way around. I have done some searching on the internet and various forums but I am struggling to find any answers.
    I have a workbook with 3 sheets - "2016", "Payment Plan" and "Paid" On the sheet "2016" I have reference numbers in column A with various other details in corresponding columns upto column G. Sheet "Payment Plan" is the same as sheet "2016" but does not contain all of the records - the reference numbers in Column A will match to column A on sheet "2016". What I am looking to do is when "Paid" is entered into column H on sheet "2016" I want to search for the contents of column A in that row, on the "Payment Plan" sheet and if a match is found delete the entire row, and ALSO copy the whole row from sheet "2016" to the last row on the "Paid" sheet and then delete from the "2016" sheet. Is this possible to do using VBA? I would greatly appreciate any help on this matter

    Thanks
    JP

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: VBA To search for Cell Value on a different sheet and delete entire row

    Ion78p welcome,
    Yes it is possible with VBA.
    It will seriously help and speed up if you attach a sample of your file
    PCI
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: VBA To search for Cell Value on a different sheet and delete entire row

    See next code in tab 2016
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Replies: 6
    Last Post: 01-13-2015, 12:35 PM
  2. [SOLVED] Delete entire row based on cell value in another sheet
    By DespoExcel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-21-2014, 01:43 PM
  3. VBA search and delete entire row in DataCapture VBA code - HELP
    By skop89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 07:09 AM
  4. [SOLVED] VBA to find Column, search the cell value and delete entire row on condition met
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2014, 01:23 PM
  5. [SOLVED] Move entire row from one sheet to another based on cell value & delete the original row
    By ceciliacrawford in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-08-2014, 03:12 AM
  6. Macro to search one column for value and delete entire row if there
    By MCONWAY in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2012, 06:00 PM
  7. Search value and delete entire row. VB
    By RobM_01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2011, 01:22 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