Search results

Hello BIGME, Glad to hear from you again. I understand you wish to delete every row in sheet2 if the value does not match in sheet1. Fortunately, you can easily do this using the following VBA code: Sub DeleteRowsNotInSheet1() Dim ws1 As Worksheet, ws2 As Worksheet Dim lastRow1 As...

Dear Faisal, Glad to hear from you again. Thank you for the thorough explanation of the problem. I understand you wish to copy data from multiple files in a folder and update it. I would recommend using the below VBA code. It imports data from files located in a specific folder and moves the...

I am glad it was helpful for you, Frank.

Dear Frank, Did you consider using the VBA function instead of the DATEDIF function? I have solved the issue using this method and it works. Here is the VBA code for this. Option Explicit Public Function Diff2Dates(Interval As String, Date1 As Variant, Date2 As Variant, _ Optional ShowZero...

You are most welcome, Dumi_Bogdan. We are glad to be helpful to you as always.

Dear Dumi_Bogdan, Welcome to our ExcelDemy forum! I understand you wish to modify the VBA code to save a file in a specific folder. After going through the given code, I think you are not including the complete file path in the OuputFileName. Instead of ChDir (which apparently has no relevance)...

Dear Bino, Good to hear from you again. Also, thanks for the detailed explanation of the problem. As I understand, you wish for a dynamic range of the source workbook to import the data into another template workbook which will have a variable-sized range too. So, here is how I modified the...

Dear BINO, Welcome to our ExcelDemy forum! Thank you for the thorough explanation. I understand you wish to set the Criteria range dynamically and as a variable size. Just like you have taken the Filter range. Fortunately, you can use the xlUp keyword to find the last non-empty cell in the...

Dear BIGME, Thank you for the clarification. But I am not sure it is possible to display rich texts (formatted texts) into a variable outside an HTML context or within a cell as you suggested. That is why I tried to show the formatting with a cell reference. However, you can try and add HTML...

Dear Mfaisal.ce, Thanks for the thorough explanation of the problem. It seems the given code extracts a file ID from the Google Drive URL and then creates a new URL to download the file using this ID. It then sends a GET request to this new URL and receives the response as a byte array...

Dear BIGME, Nice to hear from you again. I understand you wish to customize the font color and style of the strings in a cell using VBA. Fortunately, you can do that using the below code. Sub Customize_String() Range("B3").Select ActiveCell.FormulaR1C1 = _ "Dh," & Chr(13) & ""...

Dear Mfaisal.ce, You mentioned you used a code to download a single file. For multiple files, would you prefer another way? If you do, here is another easy way to download multiple files from Google Drive in a single workbook in Excel. Utilize Google Drive for Desktop to mount a drive letter...

Hello Mfaisal.ce, I understand you wish to download multiple files in a single workbook from google drive. I might be able to help you if you could share the code you are currently using to download a single file. Thanks in advance for your cooperation. Regards, Yousuf Shovon

Hello Venkatesh, Welcome to our ExcelDemy forum! I understand you wish to sum respective downward cell values while providing reference cell values. You can do this using both formula and VBA methods. However, the VBA methods seem easier in this case. Try the following VBA code: Sub...

Hello Mnor001, Welcome to the ExcelDemy forum! From the given post, I understand you wish to forecast the exchange rates for the next 9 months. Fortunately, you can do that in 3 ways using the FORECAST function, the Forecast Sheet feature, and through VBA code. In this case, utilizing the...

Dear NikosBEG, I sincerely apolozise for the misunderstanding. It seemed you wished to calculate ABSI z-score only for male cases. Thank you for reaching to us again. Your concerns are always appreciated in this community. I am having trouble to understand the ABSI value in I5 though. Do we...

Hello NikosBEG, Welcome to ExcelDemy Forum! First of all, I would like to express my gratitude for providing a thorough explanation of the issue in the Excel file. Regarding the calculation, you can utilize the formula below...

Dear Chili, Welcome to ExcelDemy Forum! We apologize for the late reply and thank you for explaining your problem in brief words. However, it would be really easier for us to understand better if you could share your Excel file. As we understand, you are facing issues to copy-paste formulas in...

Hello Yawfrank, I appreciate your concerns and sincerely apologize for the misunderstanding. Although the previous formula is displaying the whole numbers ( Prefix, Mid information, and Suffix) in my Excel 365 version, it should also work for other versions as well if you follow the...

Hello YAWFRANK, Welcome to our ExcelDemy Forum! Based on your post, I understand you wish to separate the text E057707070033 into three different cells in Excel. Assuming you have static text lengths, one easy way to do this is to merge the MID and CHOOSE functions. The formula is as follows...