Untuk mencari data/value didalam Multiple Sheets Or Workbooks?

With Excel’s Find and Replace function, you can find a certain value across multiple sheets.

1. Select multiple sheet tabs you want to find value from by holding the Ctrl key and clicking the worksheets in the Sheet Tab bar one by one. See screenshot:

2. Ctrl F ( kat within: pilih sheet /workbook)

3. tekan Option (amasukkan maklumat yg dikehendaki) - Tekan Find All.

4. result

reference:

1.https://www.extendoffice.com/documents/excel/3354-excel-search-multiple-sheets-workbooks.html