good morning,
need some assists to my task, i need to find multiple value in all cells in a sheets and then copy entire row of the cells contain the value to other sheet, kindly help me please, thank you.
regards,
bigMe
dear all,
kindly help, i need to print all sheets in a workbook, but when i do it manually, for every sheet i need to re arrange the margin, paper selection, and select printer, is there any possibility to do all this task with a macro so it will print all sheets automatically with same rules...
hello,
please help me, how to change number format so my number for thousand using ( . ) and decimal ( , )
in the region already same, in the advance option in the excel, but still the format doesn't change, maybe someone can help me, thank you.
good day,
i have a big issue because i think is it possible to do this?
i have several pdf files in a specific folder, and i need to copy some of the files and save it to other folder then open all those saved files and print it, can VBA do this?
thank you.
regards,
bigMe
dear friends,
is it possible using VBA to save an email's attachment from specific sender or subject to a folder? kindly help me how to do it, thank you.
regards,
bigMe
dear friends,
i have a task that i can't solve it until now.
what i need is, in column C will be fill with Data 3 from column G, with rules if the data in Data 1 and 2 not duplicate it's use IF+AND function (for data A001 and A002) but for data A003 it will use list data validation so i can...
dear all,
kindly help me to do my task, i have a table if i entry a value in column A then in column B make a drop down using data validation it will show only value that related to column A value, herewith i attach the sample file, thank you.
regard,
bigMe
good morning,
need your advise regarding to my macro problem.
i have a macro that doesn't work if i run from the VIEW Menu, it's always show "Subscript out of range" but in the other way, if i run from the VB editor it's work fine.
if there anybody have the same problem with me? maybe you can...
Hello,
can someone explain how to get or use a variable value?
using public or global to declare the variable only give you access to use the variable on other module but not the value in it, what i need is to use the value on other module, i hope someone can help me with this, thank you...
hello,
i wonder, is there any way to compare text between 2 cells by ignoring upper/lower case, punctuation, not in the same order, min. 2 words same is okay.
regards,
bigMe
hi everybody,
i need help and let me explain the situation :
1. i have a folder ABC (example)
2. in this folder ABC contain sub folders (Folder A, Folder B, Folder C)
3. in each sub folder contain more sub folder (Folder A contain folder A1, A2 etc)
4. in each sub sub folder contain files...
good day friends,
i have a task and i have no idea how to solve it.
task :
Note : column D (ID No.) as the key
first entry data will be store in 2nd rows below headers and it will reserve 12 rows down, so when i entry new data it will check the ID No. if it is match data copied to the next...
dear friends,
i have a sheets (name : source) that fill with several small table, kindly help me how to copy each table to other sheets (name : template) and print it, and clear the table before next table copied to template, till the last table, thank you for your help.
regards,
bigMe
hi friends,
i need some help for my task.
i have a dynamic data and what i want to do is copy and paste into new file for each rows that contains the same customer name and named the file with it and also sum the amount in column H.
herewith i attach the source file and the result of new file...
hello,
i need help how to check each row to find duplicate, but it must identical from A to C, if one of the cells is different then it's not duplicate.
after find the duplicate data, i need to copy all the non duplicate data to other sheet (sheet2) and clear all the duplicate data in sheet1...
Private Sub TarikDataKoreksi()
Dim lr, lrow, i As Long
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
Sheet_Name = "Form Faktur"
'to select folder contains workbooks
Set File_Dialog =...
dear friends,
i have a macro and it's work fine if i run it from the VBA windows, but when i assign to a button, nothing happen, can someone help me with this issue?
for other macro work fine with the button.
here is my macro :
Sub doubelKoreksiFaktur()
Dim lastRow As Long
Dim x As Long
Dim i...