Search results

I need help in building an evenly distribution model, as shown below I want to distribute the summation Total over the Days but keep giving every day only 300 and if the total cell is greater than 300 will fill only 300 then move the rest to the next day and vs if the cell is less than 300 will...

Hello Ashish, I ask to compute attrition rate from two different data sources. I have 2 different sources: 1st: employee headcount (one row per employee) which has all employee details such as Name, ID, Date of Joining, Supervisor name, Department etc. 2nd: showing data for employees who...

Hello, please, developers, I ask for help, I have a sheet called "CMS" contains columns from ("A1:BC"). I need to export these data into my SQL server from A2 till last indexed row. I want to use this sheet to stock data into SQL DB as when I update the data then migrate it I need to be...

Hello there, Please, I need help, as I have a worksheet with a huge range of data reach up to 700k rows and more and some columns which have a function. due to the long range, I can't apply the function, as the worksheet take a long time to load, or it crashes. So I search for an effective way...

hello, please, I ask for help in how can I an empty cell which I will fill it with date value and have a table from two columns [Date] & [Comment]. I need to create two buttons: 1st: Insert comment >> I will fill the empty cell with date value >> click the button >> a text field form will...

Hello there. Please i ask for an option for how can i control the chart bar manually to optmize the data source. i need to drag the bars up or down to control its data source easely. is that option is available in Excel?. if not? is there any other software provide that option. Thanks alot...

Hello, please, I need your support, I have a horizontal list of 2017 months, and I need to insert a scroll bar to alternate months and year. the workbook contains a date-picker popped up with a double click anywhere, and as soon as I create the scroll bar I found, the date picker option goes...

Hello, please I need help as I have a data for a call center answering call survey, that survey set by a customer to get us his satisfaction grade about his waiting on Queue till call center agent answer his call, I have 4 Inputs: Group of Customer Average waiting time for customers on the...

Hello there, please, I need help as I have a column which has a duplicated values within Date Range, that I keep one value then blank the other duplicated value at the same day. I used a simple function at Column I, but it needs to keep columns sorted

Hello, please I need your support at an inquiry which somehow complicated, en recap, as shown, this is a shift schedule with breaks for employees, e.g: the first agent Red color is the 1st Break start: 11:15, end 11:30 >> Duration "0:15:00" Yellow color is the Lunch Break start: 12:30, end...

Hello there, please I ask for how can I concatenate multiple Cells listed vertically into One cell split by ";" eg: Login 81287 88446 82395 81284 81296 82311 81251 82368 82363 to be 81287;88446;82395;81284;81296;82311;81251;82368;82363 thanks a lot,

Hello, please I need your support in my sheet calculation, in a recap, I work in Aluminium doors installation, and I have the bars that will be split to get the Length and the width to install doors, I have 2 sizes for this bars "600 cm" and "650 cm". the question if I have 50 doors need to be...

hello there, please I need your support in editing SQL query via VBA, i'm not familiar with SQL or VBA coding but after some serches into internet reached to have a code with SQL Connection and i set a SQL query into VBA. what i want is I have 2 static criterias used in SQL...

Hello there, please I need your support as I have a table which needs to transpose the data vertically. I want to transpose some of columns not the all table column, but each row will be transposed at autonomous table like the data that located at "Transpose" worksheet. thanks a lot,

Hello there, please i need help as i have some data in a table, there is a column that contain a string and might have a "comma" that split an items, i need to duplicate the column that have a comma 1st table: as shown @ column ("E"), there is a Comma that split the items. as shown at 2nd...

Dears, please i need help as i have a values column called "Call Date" need to verify if this column indexed in the array of Date columns "Time from()" and "time to" i need if the call date Value indexed between the dates array put a string "Valid" into "Validation" column gratefully

Hello, please i need your support in extracting Num from String as i have an array which contain a values that values be Num or string or Num concatenate String. i need to export the num records only. then repeat that extracted record till the next one

Hello there, please i need your support in getting this issue solved as shown, i need to change the colored cell's values to be (15-the filled #) by VBA code. gratefully,

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...

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 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 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...

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 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,