Please Help to solve this issue using MACRO's

**rpriyadharsini1987** · 09-02-2013, 12:24 AM

I have attahed my sample data.I need a MACRO

In this , I need a code to check the 'E' column and pop up should be displayed with the number of Duplicate values (If any duplicates found)
Eg., Duplicate values found = 4

Also One pop up should take the Status column - 'G' and should return the number of values depend on the status. It should return the below mentioned details in same pop up(Along with duplicate values).
Eg., Closed = 5
Open = 5
Waiting =3
Reopen = 57
Assigned = 65

It depends. But the value of status (eg.,Assigned, Reopen) may varry.The status may be any thing.

Please help me to sort this thing

**mahaveersomani** · 09-02-2013, 12:34 AM

he he he.....so confusion..!!! i could not understand what is your need...so tell how can i help you...if you will elborate your query in simple way so i can do something for you.....

Regards
CA Mahaveer Somani

**arlu1201** · 09-02-2013, 12:59 AM

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 POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.