Search results

  1. Yousuf Shovon

    [Answered] Get Data from Password protected PDf - Bank Statement

    Hello Nikhil Patki, Thanks for sharing your experience with us. I understand you are unable to load data in Excel from PDF about my bank statement. Well, first we need to see if the problem is limited to your first copy of the PDF. To do so: Scan your document into a new PDF file using Acrobat...
  2. Yousuf Shovon

    [Solved] Date Function

    Hello EMOHAMMED, Welcome to ExcelDemy forum! Thanks for sharing your experience with us. Regarding your problem, there is no functionality issue with your formula. However, you are using an incorrect time format with 10:00AM (no space). As you can see, Excel does not recognize this as a time...
  3. Yousuf Shovon

    [Solved] Formula to read dataset for subsequent year salary increases for multiple employees

    Hello JDB751012, Welcome to ExcelDemy forum! Thanks for sharing your experience with us. Here are some formulas you can use to read dataset for subsequent year salary increases for multiple employees: INDEX-MATCH function: Use this formula in E2: =INDEX('Future Payscale'!$A$1:$F$34...
  4. Yousuf Shovon

    [Solved] VBA to run macro with the most recent events

    Hello Rafael, Welcome to ExcelDemy forum. Thanks for sharing your experience with us. I understand you want to run the given VBA code with the most recent issues but are facing issues. As suggested, conditional formatting cannot directly solve the issue of identifying new entries in your Excel...
  5. Yousuf Shovon

    [Solved] Excel Macros & VBA in PDA Scan android

    Hello Hamza, Welcome to our ExcelDemy forum! Thank you for sharing your experience with us. It is my understanding that you want to test a VBA file on an Android PDA Scanner. The reason behind it is not working is because Excel macros will not run on mobile operating systems. VBA runs only in...
  6. Yousuf Shovon

    Request for Assistance with Monthly Group Details Report Formatting

    Hello Chili, Thank you for sharing your post with us. I understand you want to get a proper and user-friendly format for arranging a monthly details report. A well-written report should be easy to understand and brief, with a summary of the month's activities and key findings. To get assistance...
  7. Yousuf Shovon

    get a value of a cell in a sheet

    Hello Taherelchoufi, Welcome to our ExcelDemy forum! Thanks for sharing your experience with us! I understand you want to extract a value from a sheet based on the sheet name and index number. You can use the INDIRECT function or the combination of INDEX and MATCH with the INDIRECT function to...
  8. Yousuf Shovon

    [Solved] Return all dates in a specific month

    Hello Patlee, Welcome to ExcelDemy Forum! Thanks for sharing your experience. I understand you want to return all the given forms in a specific month. If your Due Dates are truly entered as valid dates as given in the below image, you should be able to apply a simple filter, i.e. Date on or...
  9. Yousuf Shovon

    [Solved] find value in all cells in sheet then copy entire row to other sheet

    Hello BigMe, Thanks for sharing your experience. You want to find multiple values in all cells in a sheet and later copy the entire row to other sheets. The conditions in the Excel file are: 1. "What if I need to find multiple values, for example, to find apple and grape (later maybe I need to...
  10. Yousuf Shovon

    [Solved] Pivot table data link to another tab in same sheet

    Hello Chili, Thanks for sharing your experience! I understand you are facing some issues with connecting Pivot table to your data in another tab. You can overlook these factors before we can reach a point of solution. 1. I have found a couple of spacing & typing mistakes in the given formula...
  11. Yousuf Shovon

    Using 3 dropdown list to generate result in 4th cell based on selections

    Hello BMORES, Thank you for sharing your experience with us! I understand you want to reveal the correspondng Risk Level for a specific combination of choices. However, you forgot to mention that not every level of combinations is covered, for instance, 3 choices don't match a row in Sheet 2...
  12. Yousuf Shovon

    [Solved] Excel

    Hello Fay, Thanks for sharing your experience with us. I understand you want to find the objectives, and equation of the constraints to minimize cost using Solver in Excel. Please, read our article Excel Solver to Minimize Cost with Examples to gain a general idea of how Solver works. Here, we...
  13. Yousuf Shovon

    [Solved] Ticket Pricing

    Hello Wanderson, Thank you for sharing the experience with us! I understand you want to figure out the optimal ticket pricing to maximize revenue using the Solver tool. Fortunately, we came up with a way to do that. Here is the idea: In the Input sheet, populate the headers with the correct...
  14. Yousuf Shovon

    [Solved] Compare two sheets and find missing and Duplicate to another sheet

    Hello John, The code returns an error because of these lines: LRow = Application.Max(ws3.Cells.Find("*", , xlFormulas, , 1, 2).Row, 3) ws3.Range("A3:Z" & LRow).ClearContents The code thinks you have existing data in the Expected Result sheet. So, it erases them first and then...
  15. Yousuf Shovon

    [Solved] Compare two sheets and find missing and Duplicate to another sheet

    I apologize I am not following you. The code provides the duplicate items with the row number, date, and quantity for both sheets. Here is an image of the duplicate items of Sheet1. If you have additional requirements, please share a demo file with your expected results in it. Thank you for...
  16. Yousuf Shovon

    [Solved] Compare two sheets and find missing and Duplicate to another sheet

    Thank you for your words of appreciation! Do you want to list every occurrence of the duplicated item from the source sheet? The reason I ask is that using Hercules Sparx 2.0 RF 24" Black as an example, there are 3 instances of that item on sheet 1 - only the second one has a date, the first...
  17. Yousuf Shovon

    [Solved] Filtering records based on a value

    Good News Amjad, Our team has worked and created a VBA code that can overcome the previous situations and find out the exact data sum that matches the criteria. Here is the code: Sub Combination_Search() 'An ExcelDemy Product Set rng = Range("B2:B134") Set CompareCell = Range("C2") Set...
  18. Yousuf Shovon

    [Solved] Filtering records based on a value

    Hello Amjad, Thank you for your words of appreciation! The code works okay but it has a bug. The code fails to find the exact sum if the data are both round and decimal numbers. In your second workbook, there is the same case. That's why you could not run it. I can give you a quick solution for...
  19. Yousuf Shovon

    [Solved] Compare two sheets and find missing and Duplicate to another sheet

    Hello John, This is an alternative VBA code to find the missing and duplicate data. The code also puts column headers in the output sheet as you asked. Sub FindMissingDuplicates() 'An ExcelDemy Product Dim sourceSheet As Worksheet, targetSheet As Worksheet, resultSheet As...
  20. Yousuf Shovon

    [Solved] Compare two sheets and find missing and Duplicate to another sheet

    Hello John, I apologize for the misunderstanding. It is now clear that you want the duplicate values of each sheet on their respective sheets. Thanks for your expected outcome sheet. You can try this code instead: Option Explicit Sub Compare_Without_Formulas() 'An ExcelDemy Product Dim...

Online statistics

Members online
0
Guests online
3
Total visitors
3

Forum statistics

Threads
287
Messages
1,240
Members
508
Latest member
HaroldDyeme
Top