Search results

Hello Amjad, Thank you for your feedback. The code fails because of the large dataset- too much data, and too many possibilities to check. Also, you have 2 new ranges now. Considering the new requirements, I was able to create a new code that filters the data in another cell matching the...

Please, see this post. Filter Records Based on a Value

Hello Amjad, Thank you for sharing your experience with us. Also, we are glad to hear the appreciation message about Md. Abdul Kader's post. We're fortunate to have him as part of our team. We will pass it along to him. Regarding your concern, I have managed to create a VBA code to filter...

Hello John, Thanks for your thorough explanation. I think this is the code you want: Option Explicit Sub CompareData() Dim wbk As Workbook Dim wshMyData As Worksheet, wshBrokersData As Worksheet, wshResult As Worksheet Dim i As Integer, j As Integer, k As Integer Dim sTmp As...

Hello John, Thanks for your feedback! Yes, you got that right. The previous code compared only the items of the 2 sheets as I thought. If you want to change the comparison ranges, we can modify the code for you. Can you specify your requirements one more time? For instances: Do we get the...

Hello John, Thank you for sharing your experience with us. Today, I am going to help you write a VBA code that compares the value of 2 sheets and finds the missing and duplicate values in another sheet. Before going there, read the below article to learn 7 suitable methods to get the missing...

Hello Sai, Thank you for your feedback! Can you please clarify this step again? You asked if Sheet2 B7: B11 is not equal to Sheet3 D7: D11, then end and move to Sheet 3 and follow step 1. But what if Sheet2 B7: B11 and Sheet3 D7: D11 are equal? Based on your criteria, I have found some...

Hello Sai, Thank you for sharing your concern. It is a bit confusing because the code runs as expected on my end. The Subscript out of range error can happen if we reference a sheet name that does not exist in the workbook. the error in this line suggests that Sheet2 and Sheet3 those we...

Hello Fred, I'm glad to hear that our solution worked perfectly for you! If you ever have more questions about Excel or need help in the future, you can always ask our ExcelDemy community. We're here to assist you with anything related to Excel. You can also find helpful Excel tips, tutorials...

Dear Fred, Welcome to ExcelDemy Forum! Thank you for your post. I understand your existing formula returns an incorrect output with the changing shifts, for instance in cell L8. Today, I will provide a modified formula that will meet your existing criteria and fix the issues given in your Excel...

Hello Sai, Welcome to ExcelDemy Forum! Thank you for posting your concern here. Today, I will assist you in converting multiple sheets to PDF using VBA. I understand you have specified 3 conditions in your post. I am going through them and have some questions about them for instance: What do...

Hello Ge0K, Welcome to ExcelDemy Forum! We understand you want to import CSV data in certain columns of an Excel file using VBA. It would be great if you could share a sample dataset or the code you have tried so far for a better understanding of your situation. However, the below article has 3...

Hello Jack, Thank you for your feedback. It's always good to know we're on the same page. Please do not hesitate to reach out if you have any further questions. Regards.

Hello Jack, Welcome to ExcelDemy Forum! I understand you want the Solver analysis tool to optimize multiple variables in the given sample worksheet. You also want to set the upper and lower limits for each variable in the Solver Parameters constraints. Well, to do so, you have to manually input...

Dear BigMe, You are most welcome.

Hello Sharyn, Definitely! With a slight modification in the formula, you can adjust to the new changes. I think you are referring to the changing Pre data to Post data now. And, the Post data are in different sheet for example the Parameter sheet. Therefore, enter the below formula in I2...

Hello BigMe, Certainly! You can find the Match or Not Match and get output in Source sheet of Bigme1(Source) workbook and show output using a VBA code from BIGME2(Code) workbook. In BIGME2(Code) workbook, save the below VBA code and run it. Sub FindAndDisplayMatches() Dim SourceWorkbook...

Hello BigMe, Glad to hear from you again. I understand you want to call the previous VBA function from another file. Also, you want to process data of columns A & F. Fortunately, the range of the VBA function we have created is dynamic which means you can input any range manually and get the...

You are welcome!

Hello Sharyn, Thank you for the thorough explanation and feedback. Based on your explanation, I have found a way to calculate whether there is a yes for each scale, for the 'pre' days only. And fortunately, the below formula works for the variable Pre rows. Enter the below formula in I3...