Clear the data Else put numbers in series by vba

hdgfss

New Member
Joined
Aug 29, 2019
Messages
41
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


 

Attachments

  • 1xls.JPG
    1xls.JPG
    246 KB · Views: 4
  • Macroxlsm.JPG
    Macroxlsm.JPG
    235.5 KB · Views: 4
  • Output(only for understanding purpose).JPG
    Output(only for understanding purpose).JPG
    233.7 KB · Views: 4

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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
 
Upvote 0
You're the one that asked it, you tell me.
 
Upvote 0
Oh sorry
Yes today i posted this question
 
Upvote 0
In future, please do not forget.
 
Upvote 0
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
 
Upvote 0
No you posted this thread yesterday, which was the 30th
 
Upvote 0
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
 
Upvote 0
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)




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)
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top