Search results

Dear Yeghi, Glad to hear from you again. I understand you wish to find a simpler way to get the results in the File Explorer, as is, into Excel. To do this, you can try the below VBA code: Sub ShowFolderSize(filespec) Dim fs, f, s Set fs = CreateObject("Scripting.FileSystemObject")...

Dear Faisal, on VBA, I added a Change event on the SO sheet to "force" calculate. See the attached Excel file for the desired dynamic function. Regards, Yousuf Shovon

Dear Yeghi, Welcome to our ExcelDemy forum! I understand you wish to export the file explorer's results to an Excel file. To do so, you could use the command window. dir *.accde > accde.txt Afterward, open the file in Notepad. If you use a CSV extension, then it will open with Excel...

Dear Faisal, Thank you for the expected results. I found a way to solve this. See the attached file and let me know if it works. Best Regards, Yousuf Shovon

Dear Faisal, Can you put the expected values in Column E, then upload your Excel file again? Best Regards, Yousuf Shovon

Hello Vodada, I think I got this now. The comments in your code show what you want to do. I have used ADODB.Recordset. and it works faster than using formula. The VBA code: Public Sub sbRecalc() ' Const Start_Data_Row = 18 Const Date_Row = 17 Const Data_Range_ColStart = "Y"...

Hello Vodada, I'm checking out your dataset, and I understand you want to type the leaves in your database worksheet and then you want them to appear on your output range that's inside your output worksheet. But I'm not sure what the Crew column is all about. Can you help me out with that...

Hello BIGME, Glad to hear from you again. I understand you wish to insert a code to check for any blank/empty cells in column A and delete that row if there is a blank/empty before you copy the data. The method you can use to fix this is to use auto-filter to filter the rows and then take...

Hello Vodada, Welcome to our ExcelDemy forum! I understand your VBA code is failing to return any output although the code returns zero error. I looked into it and the code seems to be missing the declaration and initialization of the range variables for the Employeecode, Leavecode, and crew...

Dear DSANTONE, I understand you wish to link two sheets with auto-update properties and also open a new sheet that will contain the updated values. Fortunately, you can do this using table reference properties and a VBA code. Here are the steps to do so: Firstly, select the whole range of the...

Dear DSANTONE, Welcome to our ExcelDemy Forum! Thanks for the detailed explanation. Though it would be more helpful if you could share an example file. Thanks again. Regards, Yousuf Shovon

Dear Vishnu, Did you consider using VBA for this query? I think I have solved this through VBA. I have created a VBA function and have been able to extract exact prices with respect to their closest dates. Before using the VBA code, you need to add a reference to the Microsoft ActiveX Data...

Hello Bino, Answering your question to input each search item individually, I have taken an input box where you can search for a list and it doesn't have to be a specific term. You can search for any item on that list now. Here is the modified code: Sub FilterTest() Dim lastRow As Long...

Hello Vishnu, I have reviewed your initial post and it appears that I may have misunderstood it to some extent. Thank you for the detailed explanation, which cleared things up for me. Regarding your query to find the closest matching date in Table2 <CreatedDate> to Table1 <CreatedDate> and...

Dear Vishnu, Welcome to our ExcelDemy Forum! I understand you wish to find the respective <Price> from another Table2, matching the YarnID AND the closest <Created Date>. Fortunately, you can do so by merging VLOOKUP and CHOOSE functions. Here is the combined formula...

Dear BINO, Nice to hear from you again. I understand you wish to add wildcards in the VBA code that returns only the exact values. Fortunately, it is possible to use wildcards in the AdvancedFilter criteria in VBA code to filter data that match specific patterns. Here is the VBA code to do so...

Dear BIGME, We always appreciate your concerns and responses. Follow our https://www.exceldemy.com/ website for Excel problem-solving articles. Best Regards.

Dear BIGME, I understand you wish to open the file and copy using the used range without the header and paste it to the sheet Monitoring then close the file and open the next file in the list and do the same thing and paste it to the last empty rows. Fortunately, you can do this by...

Dear BIGME, We are glad the code was helpful to you. Thank you.

Hello Gary, Welcome to our ExcelDemy Forum! I understand you wish to compose an Excel formula. Thanks for the detailed explanation although a demo dataset would be really helpful. Further, I have questions like, What are we taking as input? Is it a string saying '9 hours (1 Day and 1 hour)' or...