Search results

Hi Experts, anyone working on this please.

Hi experts, Need your help again. I need to do some changes in my file. First, when the user enters the start & end time with same day with their name, it would become red highlighted & message popped out to change the time to void duplicate (row 10 & 13). Second, when they click the submit...

Hi Narayan, Thanks for the solution. Can you please tell me more ways to represent such analysis.

Hi Experts, I need your help in presenting the week wise time used in an account. What i need is to prepare a chart in which when i select month & name, the no. of weeks & its values in that particular month would be the source data of chart. For e.g, if i select 6 as month (which is june) &...

Hi Narayan, I have to display the samples in other sheet not in the raw data. Can you please modify the sheet as I have to select randomly 4 samples per person,per month with duration as per the slabs. The formula given by you selected the samples only on basis of duration. Can you please...

Thanks Narayan. I'll get back to you in case of any query.

Hi Narayan, Please find updated sheet for your reference. I have added the data. However, if for any person, calls can't sum up to 4, then it can select the sample less than 4 calls per month. Please help me with the maximum automation on this.

Hi Everyone, I need your help in choosing the samples for quality check. The only idea in my mind is the Random function but this wouldn’t suffice as there are 2-3 conditions on basis of which sampling should be done. It should be done for 4 calls per month,per person & per type (column A for...

Hi Experts, Need your help. What i need is to calculate the final score in column "I". All parameters have weightage except M(Fatal) parameter. I have tried the formula in Column I however, i'm, not able to do distribution of score in parameters.Please help me in calculating the score on basis...

Is anyone working on it. It would be gr8 help.

Experts, can anyone please look in to this & help me.

Hi Experts, I need your help in consolidating the scorecard through macro. some of the criterias are to consolidate the scores of users for region "UK" & location "b". The header & yellow highlighted column(formulas) wouldn't change in " consolidate scorecard." sheet. It would sum the values...

Smallman, thanks for the explanation. One last question because i haven't seen such declaration till now....in below codeline what does Range("l2", Cells(Rows.Count, "l") means...may be this is a silly question for your...but please clear my doubt rw = Range("l2", Cells(Rows.Count...

Hi Smallman, really thanks for ur help & time on this. Just for the understanding, why the formula wasn't working under this codeline "Range("H1:H" & lr) = "Your Formula Goes Here"".

Deepak, if u check my initial code...i have written a formula which will extract the discount% from column D & update it in column H. For your reference the formula to be update in column h is =IFERROR(MID(d3,FIND("$",d3,1),FIND(" ",d3,FIND("$",d3))-FIND("$",d3)),MID(SUBSTITUTE(d3,"...

Hi Deepak, attaching file for your reference. I have highlighted some cells as orange. It's not filling up the cells by formula.

attachment smallman :)

Hi Smallman, Thanks so much for the code. i'm facing only one problem when the execution comes to using formula, it throws the error " application defined or object defined error". I think the way i'm writing the formula may be wrong. my formula extracts the discount% from column D & formula is...

Hi Deepak, Thanks for the explanation. Now i'm facing one problem in your code, first it is deleting the already mentioned discount% in column H whereas the formula needs to be applied on blank cells. my requirement is not to delete the existing discount %. Can you please look for this.

Hi Deepak, Thanks for the code but it's really difficult for me to understand it.Also, it's not applying the formula on column H blank cells where the column L should be selected as "discount". Can't something can be done in my code?? is that totally wrong??

hi all, please help me with a solution.

Hi Experts, really need ur help on macro. I have two problems .Please check my macro & help me with solutions for below problems. I have attached the sheet for your reference:- 1.while applying formula in the column, it selects the last cell number of column like "Range("S3959").Select"...

hey...i got it. I just removed the analysis toolpak & problem is solved. Sorry for bothering you. Thanks

Hi Faseeh, I have checked but no addin is installed in my excel & below is the code which is appearing on opening of excel in VBAProject(FUNCRES.xlam) module:- 'Entry point for RibbonX button click Sub ShowATPDialog(control As IRibbonControl) Application.Run ("fDialog") End Sub 'Callback...

Hi Experts, On opening any excel file, code for Ribbon x comes itself in module which leaves my ecel hanged & also i'm nt able to record or run any macro. I guess there is some problem due to settings but i'm unable to find it. please help me. PFA sheet for reference. Thanks