Search results

Yes, you are right, i was confused some how, but now i got it totally Thanks a lot,

Hi Luke, appreciate your effort, sorry i wasn't see the modification, if i need the free time to be exported per interval, is that available?, as i need this data as a historical for forecasting per interval level, i need to know the busy interval and the free one to cover them and make a...

Hello Luke, really thanks a lot for following, excuse me about confusion i can't apply the built-in UDF, "DATAGAP", i read the code but didn't get the UDF sequence for "missingCells" to reduce the calculation overhead you can apply the UDF for one Agent, and i'll apply for the all, thanks a lot,

Hello Luke, 1st point about user's Shift time or interval, if what about user shift i have this shifts from another report, but if the question related to how can we get the interval, i get it from the start time, i rounded the start time to nearest interval by this formula in col C...

Hi Luke, the interval in C column; each interval may be duplicated as each unique user name as per every employee may take more than one chat in the interval, my request is to extract the sum of the available time for every interval, so that in column "D", i want to remove the duplication of...

Hello, please i need help in a formula that might be complicated somehow, in recap, this sheet have Username, Interval, Chat start time An Chat end time, i need to export the available time that the agent haven't any chatting time, therefore the agent may have 2 or 3 chat at once, i have...

i'm not Obtrusive, if someone finds him self free, could offers the help, what about of sizing you are right about this issue, i ask from you to not indulged into this sheet as i get it solved, thanks any way,

@Deepak , more than one month ago for posting the Question, i didn't expect ever the above answer, any way i get my issue solved, i can upload the solved sheet perhaps some one need to benefit or to share the knowledge between us. what about of the post length is for clarification, because i...

the problem still found the range of "Monthy" selection is that copied to mail body

Monthly & Daily is a button which alternate a data in a listbox and i poppedup this retrieved data to table to be able sending via Outlook, in Private Sub Daily_Click(), i inserted MthlyDailyIdentifier = "Daily". and in Private Sub Daily_Click(), i inserted MthlyDailyIdentifier = "Monthly" i...

Dears, i have a dynamic range based on userform buttons, "Daily" & "Monthly", need when hit "Monthly" need to select range Sheets("Data").Range("B6:J11"), but when hitting "daily" need to select the range till last indexed cell to send it via outlook, the problem that i faced is the range based...

Hello @Debraj sorry to back to this post from a long time ago, i have applied your code in another sheet but face a compile error If InStr(deb & "|", "|" & varMonth(i, 1) & "|") = 0 Then deb = deb & "|" & varMonth(i, 1) i need knowing where deb is getting its value from? thanks a lot,

Mr Hui, thanks a lot, the last version do perfect job, Gratefully,

Hi Hui, so sorry, but when selecting the date from both of 2 combobox then click to filter nothing happen after click "filter" is that something must taken in consideration thanks a lot,

Dears, please i need help in filtering a range of date via combobox, i have two comboboxs need one to start the range and the second select the last of range eg: if i need to filter a range from 1- Jan till 18- Jan, 1st combobox select 1- Jan, 2nd select 18- Jan. Thanks a lot,

Hello Prsasaddn, at first the interval mean the hour's quarter, and it's arrived by rounded the "Visit time" or the chat time to nearest quarter i'm really solve it by this logic...

Dears, please i need help in an issue related to mathematics somehow, need some ideas to get the desired request, in recap, i have a worksheet that have some data listed to: >>"Agent Name", >>"Chat ID", this column have an Unique IDs for chats, >>"Visit Time" this time is concern the start time...

Dears, please i need some help form you, my workbook have a table, its contained data changes based on userform, in recap, this userform a auto-filtered listbox which retrieve its data from two different worksheets, i'm combined this exported data from the different worksheets to one table, but...

@Nebu , thanks a lot for your follow up, i'm really know how to set slicer to autofilter my data but there is circumstance that make me use combobox Hello @Debraj subba khair.. :) great work !!! Thanks a lot to get the exact answer. Dear i have another request about a list box that i used...

@Nebu please i made some modifications in datasource, i need to get the dynamic filter from sheet called "Daily Exported", and i'm resorted the fields to be as per Month selection, filter the combobox of Leader then as per Leader selection can filter the User combobox at "Daily Exported"...

Hello Nebu, perfect job, thanks so much :)

Dears, I need some support in Populating Combobox based on the selection made in another one, as i have a form that contain 3 combobox and datasource for 3 column, but the first one is related to Leader, the second is for user but need to filter the user as per what selected in Leader field as...

Dears please i have a request need some support from you, in recap, i have a workbook have a "Data" for employees daily for a year, these "data" is related to "Deduction points" and "Rewarded Points". the 1st worksheet is an interface for userform access, we will use the first that called...

Hello, is that available to bold or color a text in MsgBox via VBA as shown i insert the WD then select the start date "23-Dec 2014" and the Msgbox popped up the expected end date at the new year can i bold this end date with font size 18 and color it with red you can cross the...

Hi @bobhc , ok you can download the file from the below link using Dropbox https://www.dropbox.com/s/gj6x7lclnbitq9i/TEST2015.rar?dl=0 i have been titled the table in AHT Matrix with "Table_AHT_Mertix" and use the below formula as explained in Javier Guillén reference...