Clear the data Else put numbers in series by vba

[hdgfss]

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

1.xls

drive.google.com

Macro.xlsm

drive.google.com

 

[Fluff]

Cross posted
While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply ALL links

 

[hdgfss]

May i know to which forum i asked this question?

 

[Fluff]

You're the one that asked it, you tell me.

 

[hdgfss]

Oh sorry
Yes today i posted this question

Clear the data Else put numbers in series

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...

www.excelguru.ca

 

[Fluff]

In future, please do not forget.

 

[hdgfss]

No problem i posted this question here on 29th of this month so i forgot that i posted this question to this forum also & i posted there

 

[Fluff]

No you posted this thread yesterday, which was the 30th

 

[hdgfss]

In future, please do not forget.

Sure Sir, No doubt in it

do not waste time working on a question that may already be answered.

Sir this is a variation & this problem is not solved in any forums

 

[hdgfss]

Condition Met then Remarks in Numerical Series by vba | Experts Exchange

Find answers to Condition Met then Remarks in Numerical Series by vba from the expert community at Experts Exchange

www.experts-exchange.com

I taken the subscription here but not got any revert in 24hrs, so i cancelled that subscription(so i posted this question here in this forum without any link of experts exchnage, bcoz they will not solve this problem bcoz i cancelled the subscription)

https://www.myonlinetraininghub.com/excel-forum/vba-macros/clear-the-data-else-put-numbers-in-series

I pasted the question here(I already know that they will not solve this problem, bcoz the last 2 question i asked in this forum the reply was this is home work so inshort they will not solve this problem that i know, But my job is to ask question & solve my problems & i was doing the same & thats y i have not shared the link of this post at the starting of this post in mrexcel forum)