Results 1 to 9 of 9

Clear the data if matches in sheets

Threaded View

  1. 09-01-2020, 09:44 PM #1
    Zaeguzah
    Zaeguzah is offline
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Clear the data if matches in sheets

    Hi,
    I am looking for a macro that will do the things mentioned below

    If column E of sheet3 of 3.xlsm matches with sheet4 of Column B of 10.xlsx then match the same with column B of sheet1 of 3.xlsm & if matches then clear the data in sheet1 of 3.xlsm

    Macro will be placed in 3.xlsm file


    Thnx Alot



    Current problem is slightly similar to the below link so i shared it
    https://www.excelforum.com/excel-pro...ml#post5363120
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  2. On Close Clear ComboBox1 - ListIndex -1 and Clear not working
    By Janc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2015, 10:10 AM
  3. Need Additional Macro Code to clear out data from secondary Page after data has been chang
    By ExcelBeginner326 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2014, 02:05 PM
  4. a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10
    By Capolan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  5. Charting file template to clear old data, paste new data and update chart
    By cwilliams321 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 04:13 PM
  6. [SOLVED] Clear button, add warning dialogue box that asks: Are you sure you want to clear?
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2012, 02:41 PM
  7. Button to clear sheet and automatic clear rows
    By sandbach in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2010, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1