Search Results

Search results 1-20 of 30.

    1. Topic
    2. Replies
    3. Last Reply
    1. How to preserve formatting in excel after saving the file as .csv through vba 6

      • CapG
    2. Replies
      6
      Views
      231
      6
    3. royUK

    1. Index/match formula referring to another workbook is not working 3

      • CapG
    2. Replies
      3
      Views
      254
      3
    3. CapG

    1. Sumif function not working.Returning zero 9

      • CapG
    2. Replies
      9
      Views
      418
      9
    3. Fluff13

    1. Dynamic filter using range of values entered in either of the Fields. 1

      • CapG
    2. Replies
      1
      Views
      1.8k
      1
    3. royUK

    1. Multiple values per parameter using power query 8

      • CapG
    2. Replies
      8
      Views
      529
      8
    3. CapG

    1. The view in three data tabs to automatically refresh i.e, connected to database when the value in another tab changes. 4

      • CapG
    2. Replies
      4
      Views
      863
      4
    3. CapG

    1. Hyper links to a file with dynamic file name through variable is not working 1

      • CapG
    2. Replies
      1
      Views
      246
      1
    3. KjBox

    1. Run time error 6: Overflow 24

      • CapG
    2. Replies
      24
      Views
      1.8k
      24
    3. royUK

    1. Running through vbscript giving this error message-cannot run macro may not be available in this workbook or all macros disabled 3

      • CapG
    2. Replies
      3
      Views
      800
      3
    3. royUK

    1. Download zip files from a url through vba 12

      • CapG
    2. Replies
      12
      Views
      1.8k
      12
    3. CapG

    1. Schedule to trigger macro to run automatically on a specific time/date 7

      • CapG
    2. Replies
      7
      Views
      1.3k
      7
    3. royUK

    1. Retrieving top 10 largest values depending on its corresponding column. 11

      • CapG
    2. Replies
      11
      Views
      894
      11
    3. Carim

    1. Runtime error 1004- When trying to save a file with saveas command 2

      • CapG
    2. Replies
      2
      Views
      374
      2
    3. CapG

    1. Convert the excel formula into power query formula to compute a column 9

      • CapG
    2. Replies
      9
      Views
      733
      9
    3. rory

    1. Import comma seperated data from outlook mail body to shared excel workbook 12

      • CapG
    2. Replies
      12
      Views
      989
      12
    3. CapG

    1. Open multiple files(.xlsx and .txt) at the same time using GetOpenfilename() 4

      • CapG
    2. Replies
      4
      Views
      845
      4
    3. royUK

    1. Import certain data from comma seperated text file to excel 3

      • CapG
    2. Replies
      3
      Views
      897
      3
    3. CapG

    1. Recovery error message appears for the shared excel workbook created using macro 6

      • CapG
    2. Replies
      6
      Views
      639
      6
    3. royUK

    1. Dynamic filtering of date column using autofilter method 14

      • CapG
    2. Replies
      14
      Views
      1.1k
      14
    3. CapG

    1. Revising existing macro to be more dynamic- count the occurrences of usernames based on a date in multiple files and update the tracker 13

      • CapG
    2. Replies
      13
      Views
      2.1k
      13
    3. dangelor