danteamor

Dear All Senior Members I am new member in this thread. I would like to request you guide as vba with Sequence each duplicate value in multi columns (Scripting Dictionary). Example: Col. A Col.B Result: Col. C Col. D aa cc 1...

Hello all, I'm having trouble with conditional formatting formulas for the following percent complete versus start and end date situations. I've also included a screenshot to give you a better picture. -On Track (Trigger- Based on the current date, the task will be completed on time by the due...

I have a formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0). However, when column D and E are not populated...

On which country did the company spend the most money in Salaries in 2022? Employee ID Full Name Job Title Department Business Unit Gender Ethnicity Age Hire Date year Salary Per Month Bonus % Country City Exit Date BHR02002 Kai Le Controls Engineer Technology & Engineering Manufacturing...

i found this code for master DanteAmor https://www.mrexcel.com/board/threads/combining-data-in-listbox-on-userform-across-multiple-sheets-and-calculate-values-amongst-them.1182427/page-2#post-5758315 and i try modifay it to suitable for me but its not appear all item in column 8 when the...

Hello, I use to have a pivot for set of data and provided comments in the next column, when new data added to my data source and when I give refresh pivot table line items getting collapse and due to which my comments in the next column mismatches. I would like to add the new data into the...

Hi ? I might not express the problem as I should but pls bare with me, here it goes I'm trying to create a user data entry form to capture services per patient and save entry to my spreadsheet (database) The patient details gets populated automatically without user entry (prior to a...

Hi, Can someone help me with the below requirement. my job is at stake as it depends on this automation. Thank you in advance. I am creating below pivot table where data is based on weekending dates and grouped in to months. In column A bold ones are senior managers and list below them are...

Can someone help me with a VBA code for below requirement please. I have a data in Source sheet that has weekending date, Sales Amount, Senior Manage and Manager as below. let us say the below data is in source sheet of the current workbook. Source sheet have data from previous week also. I...

Please help with VBA code for the below operation. Column "A" will have ID's that contain the text "AB" in it and Column B has ID's that contains "EF". column "G" has all the ID's ("AB", "EF", others and blanks) Code has look if there are any blanks in Column "A" and if yes then it has to look...

i need to send by mail excel to outlook email bulk in this format Body text like same in the image, but payment terms should be change each email different. IF Possible pls share vba code

Below macro code working H2 cell only, I need multiple criteria filter H2 & H3 & H4 cells also Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$H$2" Then If Range("H2") = "" Then Range("A5").AutoFilter Else Range("A5").AutoFilter Field:=2, Criteria1:=Range("H2")...

I have a excel sheet with around 5lakh rows and i want to reduce number of rows by cumilating same data. below is the sample data (Couldn't share original data due to privacy reasons). Data should be combined based on Columns B,D,E,G. If data present in B,D,E,F columns is same the code has to...

Hi, Can someone help me with VBA code that does the following. There will be three types of values in. They are numbers, percentage and fractions. For numbers and percentages it has to subtract and produce the output. for fractions it has to subtract above and below values separately and...

I create statement sheet, which have Debit (H), Credit (F) and Balance (G) Column. Both Debit (H) and Credit (F) have Formulas to to calculate them Values. In Balance I make this Formula, =IF(ISBLANK(C8),"",H7+F8-G8) I use IF(ISBLANK just to keep the cell blank if there are no Data in that raw...