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
Hi Sholtan,
As I said in the other thread, I believe your are cross posting these questions.
The people who try to help you give up their own time.
Please read the terms for using this forum as you are in breach
https://www.myonlinetraininghub.com/excel-forum/forum-rules-and-guides/read-this-first
If you continue to cross post without linking to these posts, your account will be suspended.
Phil
No Problem Sir
I have read ur forum rules bu i haven't see about the cross pasting rules so thats y i crossposted the question
I will share the details to u Sir
May I know where I have posted this question?
