Results 1 to 1 of 1

Thread: Clear the data Else put numbers in series

  1. #1
    Banned Leonardo1234's Avatar
    Join Date
    Jul 2018
    Posts
    5
    Articles
    0
    Excel Version
    2013

    Clear the data Else put numbers in series



    Register for a FREE account, and/
    or Log in to avoid these ads!

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


    there are 2 files 1.xls & macro.xlsm (macro will be placed in macro.xlsm),both files are located in different places so the path will be hardcoded in the macro so that i can change it as per my needs


    sheet name can be anything


    plz see the sample file


    Condition: If column D of 1.xls matches with column E of 1.xls Or If column D of 1.xls matches with column F of 1.xls then match column I of 1.xls with column B of Macro.xlsm & if it matches then clear all the data in that row from column C


    Or


    If column D of 1.xls does not matches with column E of 1.xls & with Column F of 1.xls too.. then put the remarks in series (numerical series)


    Thnx For the Help
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •