Help Needed for this Macro

[asivaprakash]

I have worked this below macro and was succesful in one out come but the others are not working

1 Delete 2861 from store
2 Delete DXJ8934\MXA8484\RCF959 from Processor
3 Delete + values(amt) in PLUS (cardtype)

The below code works for Delete 2861 from store.The other two need to be in the same shee and start working once option 1 finishes then option 2 should kick in then option 3.Can any one help

Please Login or Register  to view this content.

https://hotfile.com/dl/224531363/f32ec0c/123.xlsm.html

This is the sample data I have added the comments on it as well.Can any one help

[JasperD]

I took the liberty to write you a smaller and somewhat easier to understand code.
Tried on your sample sheet and worked fine, so try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[xladept]

Hi Asiva,

See if this is what you want - If it is then uncomment the penultimate line and delete the last line.

What will happen is that it will turn all of the entries that would be deleted red

Please Login or Register  to view this content.

[asivaprakash]

Worked like a charm

[asivaprakash]

Dear JasperD

With regards to PLUS

It should delete only Positive values meaning 3000 , 4000 and the remaining negative values -3000 etc should remain . Any thoughts

[JasperD]

Hi asivaprakash

sure, change :

Please Login or Register  to view this content.

to this :

Please Login or Register  to view this content.

Please click the * below if this helps

[asivaprakash]

Sure thing that was fast but

It should delete positive values only when the Code is PLUS

Meaning If Plus and Greater than 0 delete hope this clarifies sorry for not being specific

[JasperD]

Sorry, misunderstood.
Change as follows :

Please Login or Register  to view this content.

Is that what you mean?

[arlu1201]

Asivaprakash,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

[asivaprakash]

Yes sir that's what i wanted

[arlu1201]

asivaprakash,

Please check the 1st point in post 9.