Results 1 to 2 of 2

Thread: Find Formula

  1. #1

    Find Formula

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a huge workbook with 100+ sheets and am having to search through the whole thing for multiple values. I was wondering is there might be a way I could create another workbook that could find all of the rows that contain the value "1" and collate them into a single workbook? The whole workbook looks something like this:
    Container InformationA InformationB InformationC InformationD InformationE
    1 A1 B1 C1 D1 E1
    2 A2 B2 C2 D2 E2
    3 A3 B3 C3 D3 E3
    4 A4 B4 C4 D4 E4
    5 A5 B5 C5 D5 E5
    6 A6 B6 C6 D6 E6
    7 A7 B7 C7 D7 E7
    8 A8 B8 C8 D8 E8
    9 A9 B9 C9 D9 E9
    10 A10 B10 C10 D10 E10
    11 A11 B11 C11 D11 E11

  2. #2
    All the information in each Sheet are in the cells that you shown? A1, A2,etc? If you put a picture or the workbook, it would be easier to find an answer.
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts