Search results

Hello Duane, Thanks for sharing your problem with us. I understand that you want to count the number of no-feedback cells (i.e. blank cells) for each criterion (Regional values) in your dataset. We can accomplish this by using the COUNTIFS function. To demonstrate the solution to your problem I...

Dear Vishnukumar, I checked the code for 150 rows and 13 columns. After executing the code, I received the mails properly. Here is a sample mail: All machines that require calibration within one month are listed properly here. Below is the link to the Spreadsheet used for this solution. New...

Hello PJR, Welcome to ExcelDemy Forum. I understand that you have a table to extract information from each sheet of the table and you want to avoid manually re-entering the formula with a different sheet name while extracting information from a newly added sheet. We can execute this by listing...

Dear john7777, After filtering the ABC and XYZ files, I found 226 missing data. As the XYZ file had 189 rows before copying the missing rows, there should have been 226+189 = 415 rows after copying the missing rows. However, among the 226 missing rows, 4 rows were present twice. For example...

Hello Paps6, Thanks for sharing your problem with us. The diamond shape in the top left corner of the cells of your worksheet is Error Checking Indicator. This shape appears because you have stored numbers as text in your workbook. There are two ways to resolve this problem. Solution:1 First...

Hello Michelle11, Thanks for sharing your problem with us. I understand that you want to take values from number columns and put them into the Total columns for each table in every worksheet. As you require 25 tables with 4 tables on the first page and 3 tables on the remaining page, we will...

Hello chili, Thanks for sharing your problem with us. I understand you want to add the Tenure Location names to a chart. Based on the type of chart you require, there are multiple ways to incorporate the Tenure Location names into the chart. Here, I will add a 2-D Column Chart for Total Count...

Dear Vishnukumar, I checked your code. There were a few small discrepancies in your code. I edited those errors and tried the code for a dataset that contains 40 rows and 10 columns. Here is the updated code for your file: function UpdatedCodeForCollatePendingTasks() { //Define spreadsheet...

Hello Vishnukumar, Welcome back to ExcelDemy Forum. Google Sheets support a maximum of 10,000,000 cells. So, based on the number of cells available, you can add as many rows as you want. However, the maximum number of columns supported in Google Sheets is 18,278. Hence, the above code should...

Hello john7777, To change the range D3:F for both files, you have to modify the ranges. Here is the modified code: Sub Update_XYZ_File() Set XYZ_file = ThisWorkbook Set ABC_file = Workbooks.Open("H:\New folder (2)\New folder\ABC.xlsm") 'provide file path of your required file...

Hello bigme, Thanks for sharing your problem with us. I understand you want to copy every sheet from the workbooks opened for the given target_string and paste it into a new workbook. We have to loop through each sheet of each opened workbook and copy each sheet to the new workbook. Here is the...

Hello john7777, Glad to hear that the macro worked properly the first time. However, after executing the macro for the second time, no missing data was found. Hence, there was an error while copying the missing_data range. We can add a simple If statement to check for an empty missing_data range...

Dear john7777, Thanks for your feedback. If the ABC.xlsm file is in H:\New folder (2)\New folder directory then you can apply the following code: Sub Update_XYZ_File() Set XYZ_file = ThisWorkbook Set ABC_file = Workbooks.Open("H:\New folder (2)\New folder\ABC.xlsm") 'provide file path...

Hello john7777, Welcome to ExcelDemy Forum and thanks for sharing your problem with us. I understand that you want to copy data from the ABC file which is missing in the XYZ file and paste it into the XYZ file. You used ADO Database properties to copy missing data from. However, many parameters...

Dear bigme, Thanks for your feedback. Yes, you are right. the Dim subsub_folder as Object is a typing mistake. However, the above code would still work as expected. Although the variable sub_SubFolder is not declared as an Object, Excel VBA will take it as an Object based on the properties used...

Hello bigme, Thanks for sharing your problem with us. I understand that you want to open files with a target string from the sub-subfolders of a given folder. I have prepared a folder on my computer according to your specifications. The folder consists of subfolders and sub-subfolders. The...

Hello mathi, Welcome to ExcelDemy Forum and thanks for sharing your problem with us. I understand that you want to add leading zeroes for 0 to 9 while copying the numbers 0 to 15 from another sheet. We can accomplish this using the TEXT function. Here, I have taken the numbers 0 to 15 in a...

Hello Upper West Sider, Thanks for sharing your problem with us. I understand that you want to extract the middle name from a full name. For this purpose, first, I used your mentioned formula in Cell B2 to extract the first name from Cell A2. I will use this first name output to extract the...

Dear satyak, Thanks for sharing your problem with us. I understand that you want to combine cell values from two rows to one cell. As the data in your provided sample contained numerical values, I can show you two methods to merge the required values. Here, I will use the following dataset-...

Hello Ash, Thanks for sharing your problem with us. Your code for copying cells in column A for a specified number of times has some minor problems. You assigned the value of Cell C2 (specified number of times the copy operation will occur) to variable j and later used the j variable to iterate...