Search results

@Luke M sorry to back to this thread again after this long duration because i depend on this calculation too much, in recap, this sheet that get the free time (Gap) between "Last time" with "Start time), but there is something go wrong and i can't got it as shown the colored cells...

Hello there. Can i use a text box or lable instead of using the list box to solve this issue. Is that will be available?

Dears, please i need help in solving this issue, as i have a code that let me filter multiple field to filter a data to userform listbox. but the data that i need to get considered as a long paragraph "text", i want to preview in multiple lines but not one line also need to copy to clipboard...

Okey it will figure out a result because it seemed applied to integer, but not to the fractions so when i apply the CF Duplicates find the entire is colored as a duplicated i need to apply the function to figure out the duplicate for the fraction but not the integer Thanks a lot,

Hello, please i need help in finding the duplicates in Fraction values, i have a data for Date, time, Date+time. i can't apply the duplicate filter for that field Date+time called "Code" thanks a lot,

hello Chihiro, your calculation go well, thanks a lot for spent effort. gratefully,

according to what i understand you can put this formula =IF(ISTEXT(D6),0,D6*$E$5) in "E6" and drag down

Hello there, please i need help in counting the number of annual vacation for an users through multiple years, based on the hiring date and the last working date for each user. every use take 21 vacation days per year so per month it supposed to take 1.75 day. so if an user hired in 1-jan-2015...

Hello Chihiro, the last updated code works fine, thanks a lot for your support :)

you can download it from the below link https://drive.google.com/file/d/0BwxxQXMJl4FLX2FFQUNmOC1hMW8/view?usp=sharing although there is no a huge amount of data but it sized 6m !!!, as soon as you open the workbook at "Mail" sheet, hit the mail image to popup an userform alternate between...

Hello Chihiro, unfortunately the above code didn't get the indexed range only, in additional to it omitted the option of index till last row. Gratefully,

hello there, please i need help in modify the below code plus selection the range till last indexed row i need to select the range till last indexed column not to ("Q") Dim rng As Range, OutApp As Object, OutMail As Object, lr% Dim lastColumn As Integer On Error GoTo 0...

hello there, please i need help in a function that get the header name if the cell value is greater than "0:00:00" as per the mentioned pic at cell ("U2") the value is greater than "0:00:00" so i got the header name at "Comment" column , i need to get this comment via function, then we...

the function code of "Month" combobox Private Sub Month_list_Change() Dim shtDailyExport As Worksheet Dim varMonth As Variant Dim varsuper As Variant Dim varTeamLeader As Variant Set shtDailyExport = Sheets("Data ()") varMonth =...

Hello there, please i need help to modify this code to autofilter form combobox dynamically, but sounds like there is a trick with my code Private Sub Super_list_Change() Dim shtDailyExport As Worksheet Dim varMonth As Variant Dim varsuper As Variant Dim varTeamLeader As Variant...

Hello Deepak, that is what i was really looking for :) thanks a lot for your support..

Hello there, please i need help in transposing data from horizontal order to vertical, as shown i need to convert this screen to Note: the range of the main data is variable. Thanks a lot,

hello, please i need to know how can i work with the fractions to concatenate it with string but turns to a decimal eg: ("A1"): 1.55 ("B1") "String", i need ("C1") to be "2 String" or ("A1"): 1.35 ("B1") "String", i need ("C1") to be "1 String" gratefully,

hello there, please I'v a problem in using Index & match logic, as, once get values and once turns with 0, i need to take a look to the attached then find the reason perhaps may related to the data source. at col (K) i used =INDEX(D:D,MATCH($H2,$A:$A,0)), the logic is visually true but it...

Khalid, thanks a lot, i got your point in creating logic, the format get valid, merci,

Hello there, please i need help, that i have a sheet exported from software, there is a date column didn't usually putout a valid format, what i need is export a valid format date from this column the exported date in Col B, i put an equation in Col D to try getting a valid format but in...

Hello, Does that solvable via solver? Thanks a lot,

for 1st break, i need the cell to be filled with "B1", for 2nd break: "B2", for last break "B3"

Hello, i have an employee shift schedule, that need to distribute the daily breaks within each interval shift but as per some conditions, From Row 14; each row considered an employee shift, in need to give every agent 1 hour as a break the build conditions: >> every agent must take 3 breaks...