Search:

Type: Posts; User: muhammad susanto

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. hi sandy, thank you, i will try.

    hi sandy, thank you, i will try.
  2. hi sandy, thank but not work i confuse in this...

    hi sandy, thank but not work
    i confuse in this line Select Value then Attribute column then Pivot Column , after i do that show message "Invalid cell value '#N/A'
    i try to copy this formula but not...
  3. hi sandy... here new attachment file before &...

    hi sandy...
    here new attachment file before & after sort
    i want to when refreshing data, blank cell/empty cell keep don't show
  4. PQ: Formula Sort Only Not Blank/Rows Data

    hi all..

    how to sort data exclude blank/empty rows based on column C "name of city" .
    data empty in column C till BU, the other column are contains formulas.
    how to make formula in PQ to fix...
  5. Replies
    1
    Views
    3,107

    VBA Copy Tables from Word to Excel

    Cross posted
    http://www.eileenslounge.com/viewtopic.php?f=26&t=37822




    hi all.

    i found code from google but i don't how the code is worked well, i have testing but not work
    i want the...
  6. VBA Import Table From MS Word Included Format

    hi all.
    the code work properly to import tabel from ms word to excel

    Sub ImportWordTable()
    On Error GoTo errHandler
    Dim wordDoc As Object
    Dim wdFileName As Variant
    Dim noTble As Integer
    Dim...
  7. hi expert.. maybe my attachment new file make...

    hi expert..
    maybe my attachment new file make more clear & easy , now my target photos in cell C16, E16, G16, I16
  8. hi Alan, thank you but i am still confuse how to...

    hi Alan, thank you but i am still confuse how to combine your code into my code
    like in post #1, with my code i can't select all pictures from 1 folder to inserted..
    second problem, after can...
  9. hi Alan, thank you but i can't see photos.. i...

    hi Alan, thank you but i can't see photos..
    i have run with your all code
    i have suite path file location but still not working
    after running that code, showing
  10. VBA : Insert Pictures With Multiple Select Picture & Consecutive Placing

    Cross posted
    http://www.eileenslounge.com/viewtopic.php?p=292701#p292701





    hi expert..

    this macro code below working properly to insert picture from a folder with one by one select...
  11. hi.. DocAElstein. thank you so much!!!...

    hi.. DocAElstein.
    thank you so much!!! Brilliant, Working great!!


    OK, yous welcome, thanks for the feedback :)

    Alan
  12. Vba - Check String/Text From Multiple Workbook Without Opening All Files

    hi all..

    i have 5 excel files with the same format and the same name sheet (Sheet1) into 1 folder
    i want macro to determine or check if one of files or more 1 files contains string/text (any...
  13. sandy, thank you, i think it make clear for me now

    sandy, thank you, i think it make clear for me now
  14. hi sandy..here i attached 2 files that contains...

    hi sandy..here i attached 2 files that contains my problem above
    file "test_batam" is contains problem
    please, if you find what happen give me what's the real problem & how to fix it
  15. hi sandy, my problem when i running power query...

    hi sandy, my problem when i running power query so slowly for when append data 1 million rows...the fact, my data rows not reach 1 million just approx 3000 rows
    i don't know what happen with my...
  16. for 1 question, for each file aprox 3000 rows i...

    for 1 question, for each file aprox 3000 rows
    i have 5 files actually for each file contains 3000 rows but while i process append file, only 3 files with normal rows insert approx 3000 rows for 2...
  17. hi sandy666, thanks again..

    hi sandy666, thanks again..
  18. i have problem for 5 files, 2 files can normal...

    i have problem for 5 files, 2 files can normal rows when appended but 3 files not normal i mean they appended till 1.048.576 but actually total rows only 5000 rows..
    how to fix this problem?
  19. Power Query : Maximum Append Rows 5000 Rows

    hi all..
    i have 5 excel files with different name
    i want to append all files with maximum rows allowed can appended e.g. max 5000 rows for each file
    how to make formula in Power Query

    thank for...
  20. hi Sandy666, i found new problem and to...

    hi Sandy666,
    i found new problem and to modified like this with the same example before it
    how to way or make formula to sort "name of city (in col C)" with sort list like this below, start from...
  21. hi sandy666, thank you so much!!!

    hi sandy666, thank you so much!!!
  22. here attached file, my target in cell C2 yes,...

    here attached file, my target in cell C2
    yes, A-Z sort that's i want
  23. Power Query Formula to Make Column Keep Retain Alphabetic When Refresh

    hi all..

    i have appended file when new refreshing data the column and rows is change
    how to make formula in PQ so that in column C "KPKNL" automatic keep alphabetic sort.
    here my attachment...
  24. hello man... i have new problem..how to insert...

    hello man...

    i have new problem..how to insert 40 pictures e.g. 1jpg, 2.jpg, etc...INTO ONLY in cell H10 for each sheet
    i try modify code Set xRg = Sheets(I).Range("h10") but not working..
    ...
  25. thank you Admin, that's i want it.. [SOLVED]

    thank you Admin, that's i want it..
    [SOLVED]
Results 1 to 25 of 37
Page 1 of 2 1 2