Replies

Hehe..thanks a zillion Wassim..it works like charm..thanks for
make it possible..regards.

Thanks for you guys kind answer..I’m hoping something like
“X” indicator while I put the X through the range..I don’t know
Wassim suggestion using the status bar.so I can see the marks
progress..sounds interesting..why don’t you demonstrates to me
Wassim…and Wassim..one more thing..FYI..i use =sum..in my formula instead of =..because i use the menu button..thats all..its still the same right..thanks and any help will be appriciated..and looking forward to see that..regards

Thank you..thank you thank you…Brooke..
It works like charm so far..
Appreciate it very much..Regards

Thanks legare..take care

Thanks and thanks Andrew..you always be my “saviour”..take care andrew..it works!!!

I’ve got the macro to unhide the rows :
Sub Unhide()
Cells.Select
Selection.EntireRow.Hidden = False
End Sub

But the data seems to be copy to all of the
hidden rows although i dont put it..i realize it after i unhide the rows using my dummy macro…seems it still needs your help again..thanks again

Thanks Legare..it works like charm..so now..
how to make the hidden rows appear again.. I try to change your macro line from :

.Offset(I, 0).EntireRow.Hidden = True
To
.Offset(I, 0).EntireRow.Hidden = False

but its not working..any ideas..thanks a zillion

As I told you before Andrew..you such a doll..
It works like magic..lol..many thanks and thanks again Andrew..regards

Thanks for the ideas..but I’ve already thought
of it.Its not suit for my task.regards

Thanks Tony..You are awesome..regards.it works like a charm

Thanks Andrew..you are excellent

Before I forget..I’m hoping something like formula to solved this thing ..
thanks

Hehe..what was I thinking..lol.missed that..now the problem solved..What can I say Andrew and Legare.except ZILLION and ZILLION THANKS to you guys….You guys are a genius..Its ok now and run smoothly..regards

before that..what i’m doing wrong with this sum formula..i want to total cell a1 and b1..the result is in cell c1..(SUM(A1:B1)..the problem is ..although when there is no data in cell a1 and b1..the c1 cell always show 0..how can I avoid this and when there is no data..cell C1 will show nothing..

Ok..back to our CF..
yup..i have to change the CF from marks to grades because of a few reason but the main reason is when there is 2 paper of single subject.let say history..there will paper 1 and paper 2.total of the marks will divide to 1.25 in order to get the total marks..let say this things happened on cell a1:d1 where cell a1 is for paper 1 marks..b1 for paper 2 and cell c1 is for the total marks..the maximum marks
for paper 1 is 40..same with paper 2..let say the student get each 20 marks in paper 1 and 2..so the whole row will turn to ..right..thats why i have to change it to grade..

1 more thing..please consider that i maybe have to expand the range..so please consider makes it the easier you can.so i can manipulate it again the future with different situation..not a demand..its a request from fellow friend..

regards

PS: please refer to attachment for more details

Thanks again Legare for the hard work..want a new chalenge.look above about my new post about
CF based on grades.and the attachment.reagrds