Search results

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...

dear Lutfor, thank you very much , it's work.... 🤩 🤩 but can you help me, if i want the value using input method and i already try it, but when i use to other module it's always ask me to input again, how to keep the value based on the first input only, so when i run the next module the value...

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...

wow.... and wow..... a lots of thank you dear Yousuf.... i am speechless... thank you once more time for your help. regards, bigMe

Dear Yousuf, big thank you for your attention, after i try to understand the method, i want to make sure that the function and the result must be in one workbook, am i correct? is there any option so that the function saved in BIGME2 but the data source and result in Bigme1? so i run the...

Good Morning, thank you dear Yousuf for your help, but i forgot to inform that i want to copy this function in a file and use it to process data in other file? how to call the function? and please inform me if i try to put data in cell1 and cell2 in column A and column F, not side by side like...