Condition Matches then clear the data ELSE put the remark in series by vba

**dumdumbum** · 07-19-2020, 05:28 PM

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 loacted in diffrent 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 equal to column E of 1.xls & column H of 1.xls is lower than column K then match column I of 1.xls with column B of macro.xlsm & if it matches then clear the data in that row ELSE put the remark

If column D of 1.xls equal to column F of 1.xls & column H of 1.xls is greater than column K then match column I of 1.xls with column B of macro.xlsm & if it matches then clear the data in that row ELSE put the remark

**dangelor** · 07-20-2020, 04:14 PM

Possibly...

Please Login or Register  to view this content.

**dumdumbum** · 07-21-2020, 03:25 PM

Please Login or Register  to view this content.

Thnx Dangelor Sir for Helping me in solving this problem But
Dangelor Sir plz run the macro on the sample file and see this macro is not giving proper output
in the sample file i have also mentioned output sheet plz see sir

**dangelor** · 07-21-2020, 04:06 PM

Is this what you're wanting?

Please Login or Register  to view this content.

**dumdumbum** · 07-21-2020, 11:49 PM

The macro is doing perfect in clearing the data but it has issue with the remark part (remark will be in series plz see sample file)
I have putted some details in sample file plz see & also i have mentioned some details also

**dangelor** · 07-22-2020, 08:14 AM

The last 2 entries each fail one of the tests, so no remark is added or deleted.

**MoldyBread** · 07-22-2020, 08:21 AM

sorry by mistakely posted the details

**dumdumbum** · 07-22-2020, 08:23 AM

Please Login or Register  to view this content.

I am using this macro & i made some changes in sheet name & path plz see & after runing the macro it is not giving correct output Dangelor Sir
So plz have a relook Sir

**dangelor** · 07-22-2020, 08:40 AM

Again, the last 2 entries fail one or the other test, so no changes occur to either HDFCBANK
or HEROMOTOCO

**dumdumbum** · 07-22-2020, 08:46 AM

No dangelor Sir plz see the output sheet that is the result of the macro
It is clearing all the data in that entire row
we dont have to delete all, we have to delte the data after column B
plz see the output sheet & how if the condition met then i have increased that by data in series plz see

**dangelor** · 07-22-2020, 12:53 PM

My apologies for not making myself clear...

Using your files and the code in post #4 will give you these results.

**dumdumbum** · 07-22-2020, 03:34 PM

Plz see both the files
& plz see the yellow highlighted colour in both the sheets & see if condition not met then how i putted the remarks in series

& also see the calculation which i made

**dangelor** · 07-23-2020, 07:46 AM

According to the logic in your #1 post, to modify any entry, it must pass two logic tests first and only then will it either be deleted or remarked. The HDFCBANK and HEROMOTOCO entries fail one of the first two tests, and therefore the third test is not run.

If I have misunderstood your logic, my apologies, but as written, I see no other way to interpret it.

**dumdumbum** · 07-23-2020, 07:53 AM

If the first two test has been passed then clear the data & if they are not passed then remark

Macro clears the data if it is passed
But if it fails then remark is needed & the given macro doesn't put remarks

Plz run the macro Dangelor Sir & See

**dangelor** · 07-23-2020, 07:56 AM

So, eliminate the third test?

Please Login or Register  to view this content.

**dumdumbum** · 07-23-2020, 09:33 AM

Thnx Alot Dangelor Sir for helping me in solving this problem Sir
Problem Solved
Have a Awesome Day Sir

**dangelor** · 07-23-2020, 09:34 AM

You are welcome!

**dumdumbum** · 07-26-2020, 08:49 AM

This macro has some issues
plz see the i have attached the sample file along with the macro Dangelor Sir

Condition Matches then clear the data ELSE put the remark in series by vba

LinkBack

Thread Tools

Rate This Thread

Display

Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Re: Condition Matches then clear the data ELSE put the remark in series by vba

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Clear the data by vba if matches

[SOLVED] copy paste the data if condition matches with dragging macro

[SOLVED] Conditionally calculate the data and paste it, if condition Matches

[SOLVED] If data matches then clear the data by vba

If condition matches copy data from one sheet to another

[SOLVED] Condition 2 matches or partial match Data retrieve

How do you count data that matches more than one condition?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions