Search results

Hi, I was checking how to plot different color of same series chart like % of actuals above SLA% and below SLA%. I did find a very good solution from Andy Pope's site, that it can be done either with formula or with VBA. I am able to get the result replicated in my book, except for one...

Hi Rahul, I am sure you have gone thru links shared by Hui for both type of solution. I thought of sharing one more method, say you have all email IDs in col A, step1. type ";" in col B for all the rows where you hav data in Col A. step2. Copy both the columns together and paste in...

Hi Jason, Try this: ComboBox1.AddItem cell.Value & " " & cell.Offset(0, 1).Value & " " & cell.Offset(0, 2).Value Regards, PrasaD DN

Hi Gaurav, share your code and the sample file of inputs so that one can understand how the sub folders are placed in inputsheet whether columnwise or rowwise and accordingly suggest the solution. Regards, Prasad DN

:-) Ratan, unfortunately, I still could not understand how you want the dates, I am sorry. :( Pls plug in some sample rows with your expected result including output covering for days of holidays, so that anyone here can help you with formulas. Regards, Prasad DN

Hi Ratan, Have you checked the Narayan's file? is that solving your issue? And, I am not clear what date you need for a holiday, for example, 6th Apr is holiday, you need the next workind day, Tuesday instead of 6th Apr or completely ignore that month? Regards, Prasad DN

Hi Ratan, also mention what date you need if the given date happens to be holiday, like 6th Apr (Monday) Regards, Prasad DN

Hi, can you pls also include the sample dates manually for some of the records, and its not clear which Monday you want to start, Jan or Apr etc. Regards, Prasad DN

Hi, Sorry, I could not understand your question. I see you already have the formulas to find duplicated entries and Negated value, so what do you want us to help you with? Regards, Prasad DN

Hi, I hope you would not have F42 with both Angle and Surface finish together. here is what I suggest as formula: =IF(IFERROR(SEARCH("Angle",F42),0)>0,G42,IF(IFERROR(SEARCH("Surface Finish",F42),0)>0,(G42/40),G42*25.4)) REgards, Prasad DN

Hi, Why not just copy the entire table and paste in sheet2? Regards, Prasad DN

Instead, protect your project code with password. To the best of my knowledge Alt+F11 combination cannot be altered. :( Regards, Prasad DN

@OP, you can also try to use outline group feature in excel. Regards, Prasad DN

Hi Ravi, See if this formula helps in H2, if yes, drag down the same: =COUNTIF(B2:G2,G2) Regards, Prasad DN

to best of my knowledge it is not possible.

Try adding the line after your time stamp code: Range(address).value = Application.username regards, Prasad DN

Hi as Marc suggests you need to give wait time after each filling. As the dropdown takes values and processes the next field based on onchange event. This will not get captured by ie.readystate. Regards, Prasad DN PS: i check your code by running line by line F8 mode and it works perfectly.

Hi Narayan, for the above said dates, 64 is correct. I am not sure how it gives 64 at your end, when I checked it was giving me 65. Anyways, I am currently good with named range option. Regards, Prasad DN

Hi Hui, Got it!! here is the changed code: ActiveWorkbook.Names.Add Name:="AgeOnDOS", RefersToR1C1:= _ "=DATEDIF(""" & VBA.CDate(DOB) & """,""" & VBA.CDate(DOS) & """,""Y"")" Regards, Prasad DN :)

Hi Narayan, I was trying with your method of taking months and dividing, but issue comes with days and dividing by 365 would mean leap year and other issues. so your solution is not working for me. take example of two dates with just 1 day before dob scenario: Sub test() Dim DOB, DOS As...

Hi Hui, Thank you for your response, but first date and second date are variables in my vba. so cant include them in named formula. Regards, Prasad DN

File attached.

Hi Igor, As you have macro enabled file this is quite possible. Paste this code in matrix sheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim bRiskFound As Boolean Dim sRiskID As String Dim sht As Worksheet Dim iHighlightRw As Integer Dim Rng As Range If...

Hi All, I need to find if the person is more than 65 years or not, on the date of service. I have date of birth as say 06/12/1950 (mm/dd/yyyy) format. And the date of service is 01/16/2015. When I use =DATEDIF("6/12/1950","1/16/2015","y") formula in excel sheet, it gives 64. which is...

Hi Marc, I understand what you are suggesting, but I had a situation where the pop up of IE will not get recognized by the running macro. And the IE page will not proceed until the pop up is dismissed, and the Macro will also keep waiting without proceeding further, even if you code wait...