Search for a value in entire workbook, return the entire row where value was found
Hello All,
Example: I have 10 Invoice numbers (C093705926 C093705927 C093725527 C093750757 C093750759 C093769955 C093769956 C093789382 C093808525 C093808526) and need to search these in a workbook where they are all located.
1. Can I search for them at the same time?
2. Even if I cannot search for them at the same time, is it possible for the search to return the entire row “C093705926” is located in?
3. What happens if I have to do this for 200 invoices, will this mess up my workbook?
Thank you!
Hello All, Example: I have 10 Invoice numbers (C093705926 C093705927 C093725527 C093750757 C093750759 C093769955 C093769956 C093789382 C093808525 C093808526) and need to search these in a workbook where they are all located. 1. Can I search for them at the same time?2. Even if I cannot search for them at the same time, is it possible for the search to return the entire row “C093705926” is located in?3. What happens if I have to do this for 200 invoices, will this mess up my workbook? Thank you! Read More