Recent content by bigme

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 Lutfor a thousand, correction.... a million thank you for the solution 🤩 regards, bigMe

thank you very much... i miss to uncheck the system separators, thank you again.... 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...

dear Lutfor, thank you very much, it's a big help for me..... regards, bigMe

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 Lutfor, thank you for your response, is this code can run if i copied to a module? because i want to merge & modify with other macros, thank you regards, bigMe

hello, kindly help me please, how to sum data in dynamic multiple range? thank you.

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

good morning, dear Musiha, thank you very much for your explanation, it very clear..... 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

dear Seemanto, thank you for the explanation, for your information the error always refer to Set sh1 = Worksheets ("DATABASE"), is there any miss type in my code? regards, 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...