hi sandy, thank you, i will try.
Type: Posts; User: muhammad susanto
hi sandy, thank you, i will try.
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...
hi sandy...
here new attachment file before & after sort
i want to when refreshing data, blank cell/empty cell keep don't show
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...
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...
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...
hi expert..
maybe my attachment new file make more clear & easy , now my target photos in cell C16, E16, G16, I16
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...
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
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...
hi.. DocAElstein.
thank you so much!!! Brilliant, Working great!!
OK, yous welcome, thanks for the feedback :)
Alan
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...
sandy, thank you, i think it make clear for me now
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
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...
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...
hi sandy666, thanks again..
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?
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...
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...
hi sandy666, thank you so much!!!
here attached file, my target in cell C2
yes, A-Z sort that's i want
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...
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..
...
thank you Admin, that's i want it..
[SOLVED]