Threads by mathew31

    1. Title
    2. Replies
    3. Last Reply
    1. using macro to code a pie chart 2

      • mathew31
    2. Replies
      2
      Views
      1.5k
      2
    3. apo

    1. using the open file dialog box to avoid hard coding the file names.......... 20

      • mathew31
    2. Replies
      20
      Views
      6.5k
      20
    3. royUK

    1. using a dialog box to select the file for consolidation 39

      • mathew31
    2. Replies
      39
      Views
      9.8k
      39
    3. mathew31

    1. using either arrays or auto filters to delete rows based on criteria. 27

      • mathew31
    2. Replies
      27
      Views
      6k
      27
    3. mathew31

    1. using autofilter to remove irrelevant data 13

      • mathew31
    2. Replies
      13
      Views
      5k
      13
    3. pike

    1. working with arrays to reduce code execution time. 2

      • mathew31
    2. Replies
      2
      Views
      1.3k
      2
    3. royUK

    1. reduce code execution time 169

      • mathew31
    2. Replies
      169
      Views
      27k
      169
    3. jindon

    1. count the number of columns until the first blank cell is encountered. 7

      • mathew31
    2. Replies
      7
      Views
      8.6k
      7
    3. Smallman

    1. copy entire columns from multiple workbooks(one sheet each) to a main workbook sheet 15

      • mathew31
    2. Replies
      15
      Views
      5.9k
      15
    3. mathew31