Search results

Dear All, Can you please advise if an email can be sent automatically to a person; if a call value reaches below a limit. can this be possible Best Regards, Brijesh Keni

Hi Hui, when i change the value of the E49 to 2 then it highlights the following row. Rows("50:53").Rows.Hidden = False when i select 4 it then highlights Rows("50:55").Rows.Hidden = False Can you please advise how can this be achieved. Best Regards, Brijesh

Hi Hui, when i change the value of the E49 to 2 then it highlights the following row. Rows("50:53").Rows.Hidden = False when i select 4 it then highlights Rows("50:55").Rows.Hidden = False Can you please advise how can this be achieved. Best Regards, Brijesh

Hi Hui, when i change the value of the E49 to 2 then it highlights the following row. Rows("50:53").Rows.Hidden = False when i select 4 it then highlights Rows("50:55").Rows.Hidden = False Can you please advise how can this be achieved. Best Regards, Brijesh

Hi Hui, when i change the value of the E56 to 2 then it highlights the following row. Rows("28:35").Rows.Hidden = False

Hi Hui, Just wanted to check again on the same topic...I am actually having an error when i protect the above sheet. it gives me a run-time error '1004'. it also mentions 'Unable to set the hidden property of the range class' Can you please advise. Best Regards, Brijesh

Hi All, Can you please advise If text can be added in the logical test. IF(D1="Group Leader", Yes, No) But when D1 is Group Leader it displays the result as No Please advise. Best Regards, Brijesh Keni

Hi Luke, there was no confusion.. on the positive end i learnt some new functions..thank you the same. I am not new to excel but am in the intermediate level Best regards, Brijesh

Hi Luke, Thanks a lot for you expertise. It works fine now.. Best Regards, Brijesh

Hi Luke, I tried the formula but I am getting an error as '#N/A'. Can you please advise. probably the problem is in the MATCH function Best Regards Brijesh

Hi LukeM, Thank you for your valued information. What i was looking for is as defined below: we have three columns A,B,C and rows 1 - 6 as shown below. what i want to do is for example if i have 340 mangoes, the formula would give me search column A and give me OUTPUT 350. can you advise if...

Hi All, I need to compare a value in a cell; say 'D4' with series of numbers; say 'F2:F9'. lets say the values in each cell from F2 to F9 are: F2 - 2 F3 - 4 F4 - 5 F5 - 6 F6 - 7 F7 - 8 F8 - 9 F9 - 10 If D4=6; then i would need a formula which would compare all values from F2 to F9...

Dear Hui, Thank you very much for your valued expertise. Really appreciate your help. It is working fine now. Best Regards, Brijesh

Hi Hui, Thank you for your valued information. I did try it but it does not work for "$E$56". it does work well for "$E$49". Actually i am trying to add multiple events like as follows. can you advise if this could be possible. Best Regards, Brijesh Private Sub Worksheet_Change(ByVal...

Hi Narayan, As advised i tried the following but the target cells did not respond.Can you please advise what could be the reason. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Select Case Target.Address Case "$E$49" Case "" Rows("50:56").Hidden =...

Hi Narayan, But what if i need to add multiple worksheet_change macros. Can you please advise? If there any tutorial you can suggest for beginner level to learn this. Best Regards, Brijesh

Dear All, I was trying to use two worksheet_change macros in one sheet further to which i was getting error. Can you please advise what could be wrong? the macros are defined below. Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Target.Parent.Range("E48")...

Hi oldchippy, Thank you for your valued input, got something new to learn. But i am looking for a way where on selecting the drop down value ( from 1 to 10). If i select 2 then automatically 2 drop down menu lists will pop up and respectively. Can this be possible? Best regards, Brijesh Keni

Hi All, Am new to this forum and was enlightened to observe such valuable information flowing. I am actually trying to adapt the behavior of group of cells or rows depending on the value of one cell. Just to illustrate it: I have created a drop down list on 'Cell 1' (from 1 to 10)...