Search results

Dear Jululian, Thanks for reaching us. I understand that you want to make a value positive or negative based on another cell’s value. To demonstrate your problem, I have taken a similar dataset to yours. Since you want the positive or negative values in Column C, I have taken the actual...

Dear amberprepare, Thanks for reaching us. I understand that you want to add a rank or count that restarts every time you change to the next employee. For that, I used a similar dataset to yours and inserted the following formula in Cell C2 and dragged the Fill Handle icon to copy the formula...

Dear Ammar, Thanks for reaching us. I understand that you want to use an Excel formula to find the all balance values of "Ali" and display it in the "Result" column. There are two ideal solutions for this problem. Here, I have taken the filter value “Ali” in Cell E2 to accommodate my...

Hello Jasper.Muduvhadzi, If you have tried to enable macros in the Trust Center but are still receiving a message that your macros are disabled, you can try the following methods as a solution: Enable macros for a specific workbook: Open the xlsm type Excel workbook. In the Message Bar that...

Dear SpicyVNoodle, Thanks for reaching us. I understand that you want to rearrange your data into a report format. To rearrange the data in your specified format, first, you have to create a Sheet named “Report” in your Excel Workbook and then manually write the required headers in Row 1...

Dear reza_akbar, To save the file in a specific path, you must include the folder path, file name, and extension in the Filename argument of the SaveAs method. The modified code is given below: Sub SaveIt() Dim dt As String, wbNam As String, savePath As String 'Enter your workbook name...

Hello hassan99663, Sorry for the inconvenience. The error occurred due to my dataset starting from Cell B2. I have modified the code according to your dataset now. Sub sendRecordsViaEmail() Dim outlook As Object Dim newEmail As Object Dim xInspect As Object Dim pageEditor...

Hello hassan99663 Thank you for contacting us. I understand you want to email multiple records associated with a single email address. You can implement a VBA code to obtain the required result. I have taken your provided dataset in a sheet named “Sheet1”. You may need to change the sheet name...