vba code

Dear All master, Please help me to make vba code. What I want in the bca sheet in column B which only contains "KR AUTOMATIC LLG" then the numbers are removed and I have marked yellow. LINK https://drive.google.com/file/d/1iok21UA86tH0KMTyTRMqiBYoCSukJfYw/view?usp=sharing Thanks roykana...

Hello Everyone, Good Day ! I'm learning about excel vba coding and i have an excel file which is something like small invoices sheets and i have added one more sheet like summery/report. Only i want to make copy and paste some specific cells from invoices to summery sheet, attached small...

Hi Masters, I would like to ask help about a vba code that can help me removing unwanted columns base on the data..and too just enter it in a inputbox or pop up box with multiple data separate with comma. here is a sample: i wanted to remove the columns in yellow, by just entering their data...

I have a worksheet that has cells with links. is there a vba code for remove the existing values after the word " jpg" ??. I have multiple cells with this kind of links and removing the existing values after jpg is really a pain by doing it manually one after another.. Please help me. see...

Hi, can someone please help with the VBA code for splitting a WBS column into the individual columns. Just need it for 4 levels and usually in excel i can just have a if statement that bases it on the number on ".". is there a cleaner way to do it. my WBS child numbers can be multiple...

Hi Team, I need a vba code which can jump to the same location in the next column same row in the same position in Word table as attached in the image. On pressing Alt+Right or Tab the cursor moves to the starting position of the cell. I would like to jump the cursor directly to the same...

Like the title says. i written a code which lets me add sheets and rename them accordingly. But since i changed something yesterday (i dont know what exactly) it just doesnt run properly anymore. that is the code: Sub DeleteSheetsBetweenFirstAndLastMarkerSheets() 'Updateby Extendoffice On...

Hi all, I have the following list: Does anybody know how I can sort this alphabetically? :) Kind regards, Jyggalag

Hi all, I currently have this formula: Right now the cell is showing a blank cell. I then have another cell that links to this cell through this formula: This cell also shows blank, because the first cell is blank. I then have a third and final cell with this formula: However, this...

Hi guys, i am new on this forum and really would like to tell you are genius!!!! i tried to do it for my excel file with all the inputs inside this forum but unfortunately i am not good enough. So, my file is an excel file with 11 worksheets. I would like a pop up message telling me when i open...

Dear All Master, I want to extract table data in html file in excel with vba code. I give the html file and excel output the link. Link file : VBA EXTRACT TABLE HTML TO EXCEL - Google Drive file Please give me a solution. Thanks Roykana

Hello all, I am looking for a VBA code to reconcile two data sets in Sheet1 and Sheet2 (See attached report). Looking for qty differences between both sheets and identifying if a column A, B or C and have any discrepancies. Can anyone help? Thank you in advance!

My laboratory is capable of running 20+ different analyses, and we get contracts from about the same 15 companies to do a combination of these analyses. I created an Excel spread sheet to keep track of the work as it comes in, where columns are the 20 different analyses we can run, and rows are...

Dear All master, I want the vba code to copy over entire folders and sub folders very fast. The vba code below can only be in one folder so if there is, I can modify the vba code to my liking and also I want the process to be very fast. Thanks roykana Sub copyfiles() 'Updateby royKana...

Dear All master, I just want the file name in column c and the extension in column d. The result I want is marked in yellow. this is my link : result.xlsm file Thanks roykana Sub ListAllFilesInAllFolders() Dim MyPath As String, MyFolderName As String, MyFileName As String Dim i...

Dear All master, Please help with vba code, I want input range with inputbox and output range with inputbox. The data is on the db sheet in column E & F which I marked in yellow and the results I want are in the results sheet in columns A, B, C. I want a very fast vba code because the data...

Hi all, I am very new to VBA and am stuck trying to edit code I already have written. Essentially, the code I have (below) was intended to loop through multiple files in a folder and pull certain data columns in from a specific worksheet. This worked fine for its original purpose, but was only...

Hello everybody, I am currently managing a stock tracking file, which is edited manually to a large extent. Currently, the four significant columns look like this: Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...

Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...

Please help me with VBA code. as I am stucked in a situation where i need to select the multiple items from drop down list available on web page, we have to select the items from list only as we are doing on Userform Listbox Control. Below is sample website where you can see the checkboxes...