Search results

Hello shiv, Thanks for sharing your problem with us. The problem you shared requires creating a dashboard. We have a professional team for creating such dashboards. Email your requirements and other relevant details to [email protected]. Regards, Seemanto Saha ExcelDemy

Dear bigme, The following block updates the set of data with any existing ID. Here, the code iterates through 12 rows from where the match was found for the user-given ID No. and updates the first empty row with the user input from the data entry form. The empty rows are checked based on...

Dear bigme, the Application-defined or object-defined error is very common in Excel. It usually occurs when an object (the ws worksheet for example) is not defined properly or parameters related to an object (the i or j variables for example) are invalid. Although it is not possible to surely...

Hello bigme, Thanks for sharing your feedback with us. The VBA code provided in the previous replies was based on the sample dataset provided. As the sample dataset contained Name, Address, City, and ID No. in Columns A, B, C, and D respectively, the ufNm, udAdrs, ufCt, and ufID variables were...

VBA Code: Sub generateReviewReport() 'declare your required number of file path variables Dim file_path1, file_path2, file_path3, file_path4 As String Dim file_pathArr() As Variant 'Assign file paths to the declared variables file_path1 = "F:\Exceldemy\FQ-182\Folder...

Hello Mythbuster, Thanks for sharing your problem with us. I understand that you want to create a review report. According to your specification, the workbook that contains the review report should have sheets named after the reviewed workbooks that contain any cells with complete or partial red...

Hello SMQAMARUDDIN, Thanks for sharing your problem with us. I understand that you want to prepare an Ageing Report from the attached Ledger Balance report. To prepare an Ageing Report, apart from the data you provided, we require Activity/Customer Details, Invoice Days, or Due Dates and a list...

Hello bigme, Thanks for sharing your feedback with us. I understand that you want a breakdown of the given code. The VBA Code used is a Click event for a CommandButton on a UserForm. Here is a block-by-block breakdown of the code. Dim ufID, ufNm, ufAdrs, ufCt As String Dim ufArr() As Variant...

Hello bigme, Thanks for sharing your problem with us. I understand that you want to create a data entry form that follows a specific format. We can create a UserForm to solve your problem. For that, go to the Developer tab and select the Visual Basic option (or, use the keyboard shortcut Alt +...

Hello Jlkirk, Here is a video that shows the process of inserting the VBA macro in the workbook. Video However, you have to Save your Master Workbook as a .xlsm file to get the required result. And if there is any problem with the VBA macro, please share your Master Workbook with us. Regards...

Hello Jlkirk, Open your master file. From the Developer tab click on the Visual Basic option or use the keyboard shortcut Alt + F11 to open the Visual Basic Editor. Afterward, double-click on the ThisWorkbook option and enter the code. Make necessary changes (name of the master file) and...

Hello Jlkirk, Thanks for reaching us. I understand that you want to open all embedded/linked Excel files automatically when the master file is opened. According to your description, your Excel files include multi-level linking (children files and grandchildren files). To open all these linked...

Hello emflorence.br, Thanks for sharing your problem with us. I understand that you want to build up a spreadsheet that displays the quantity of the items that you have in your stock for the warehouse selected through a dropdown. From your given data, I created the following dataset: To add...

Hello Gredang, Thanks for sharing your feedback. After going through your workbook, I understand that you want your “names” sheet to be anchored to the “data” sheet so that when you click on any trainee’s name in the “names” sheet, you will be able to see that trainee’s details in “data” sheet...

Hello tbergines, Thanks for reaching us. I understand that you need help organizing data. As the Solar data and Usage data are unequal in size, the missing values are filled by zero. To solve this problem, we can organize the data in a slightly different manner. From your dataset, I filtered...

Sorry for the inconvenience. After adding the table header, I forgot to increase the filtered range parameters by 1. That's why column headers were repeated. The updated Apps Script is given below: function CollatePendingTasks() { //Define spreadsheet and source data sheet var spst =...

Glad we were able to help you. About your doubt, I understand that you want to add some description in the first row and shift other data to one row below. I inserted a table header to my data to demonstrate your problem. You also wanted to add a CC in the sent mail. The modified Apps Script...

Thanks for giving us your feedback. I understand that you also want to filter the rows for which machine calibration has already expired. I modified a few Expiration Dates in my dataset for this. You also don’t want the same rows in multiple emails. This can be accomplished by adding some AND...

Hello Vishnukumar, Thanks for reaching us. I understand you want to collate pending actions and send them in a single email instead of individual mail for each pending action. We can accomplish this by filtering the pending actions first and then sending the filtered data in tabular format via...

Hello bigme, Thanks for reaching us. I understand that you want to copy and paste rows that contain the same customer name into new files that are named after customer names. We can apply a VBA Macro to achieve that. From your “source” Workbook, press Alt + F11 to open the Visual Basic Editor...