using loops,CountIf or match function

[lauren_wing]

hi

I have am attaching an excel sheet and also a text file for a clear explaination of the problem.please follow the text file as a reference of the explaination of the problem and also the excel sheet of how the input and output should be in.

Please help me with a macro.I have attached an excel file which has a sample input and the required output i require.Please help me with a macro using loops,Countif .or match functions Dynamically so as to reduce preformance when Using it for large data such as around 50000 rows or so.The macro has to be dynamic.The code should run for any number of rows dynamically with reduced amount of time.


please attach a note pad text file or use the excel file for putting the macro code.Please.



Thank you.








Here basically we have Entry Grouping level within the Entry Level they are many Line and Grline.

There many be around 100 or 200 Line or Grline under each Entry Level.

So if the Line or Grline are having the same User id for all its Line or Grline Under each Entry Level then all the correspoding User ids should be in white color and the parent should be in black using a macro only.


example:

Grouping Level User id

Entry User 5,User7,User 6

Line User 5

GrLine User 7

Line User 6

Entry User 5, User 8, User 10

Line User 5

GrLine User 8

Line User 10


Hence here above if a Line or Grline has atleast one different User id so all the User ids should be in black color.Here we should loop all the Line/Grline Under each Entry level and see the corresponding User ids.


If there is atleast one different user id under the Line/Grline in that Entry level then all the user ids should be black in color using a macro dynamically.


here the output should be like




Grouping Level User id

Entry User 5,User7,User 6(black color as it is Entry level parent)

Line User 5(black color)(we just hav to loop thru Line/Grline)and see
correspoding user ids)
GrLine User 7(black color)

Line User 6(black color)

Entry User 5, User 8, User 10(black color as it is Entry level parent)

Line User 5(black color)

GrLine User 8(black color)

Line User 10(black color)

so on...



And if the Line/Grline is having all same User ids in that particular Entry Level then all the user ids should be in white color using a macro dynamically.



example:

Entry User 5(black color as it is Entry level parent)

Line User 5(white color)

GrLine User 5(white color)

Line User 5(white color)

Entry User 10(black color as it is Entry level parent)

Line User 10(white color)

GrLine User 10(white color)

Line User 10(white color)

Entry User 10(black color as it is Entry level parent)

Line User 10(white color)

GrLine User 10(white color)

Line User 10(white color)


Here all the Line/Grline have the same User id within its Entry Level then all its user ids should be in white color except the Entry Level as it is parent.

I have attached a file which has a sample and the required output i require.Please help me with a macro using loops,Countif .or match functions Dynamically so as to reduce preformance when Using it for large data such as around 50000 rows or so.


Please help me with a macro and also user of any functions so as to reduce the performance Dynamically.

please attach a note pad text file or use the excel file for putting the macro code.Please.


Thank you.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
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.

EDITED THIS TIME

[lauren_wing]

Thank you so much.I wont repeat it next time.i am sorry for having the tilte that way.