exce-vba

Have data in columnA and trying to filter data using keywords. member of groups is in the down adjacent cells. starting with {space} or just a cell without space. tom1.0 jerry mickey mouse tom jerry2/1 mickey3+4 mouse tom jerry mickey Mouse mickey mouse tom jerry2/1 mickey mouse...

Hello everyone Happy B Holiday. I have an data sheet whereby it has a lot information and i have created an userform1 whereby below code i have placed from another sheet that i had however when I tried to play around combobox2 wont shows any data into any the boxes or even nothing on Combobox2...

Dear All, I would like to Split and assign the splited first the 100 char in one cell. then split the char from 101 to 200 then assign it next cell the splited value via vba in excel. For example: If I receive 1000 char Split 100,100 upto 1000. But the 1000 chars are not fixed. it will be...

Hi, I created a vba script in Excel in order to create a word document as summary of comparison of 2 word documents. Here my script: Option Explicit Private Sub ButtonSummaryReport_Click() 'Initialize the progressbar and the label Dim k As Integer Dim filesNumber As Integer...

Dear Mentors, Hope you all are Doing Good !! After viewing so much videos and solution , i am able to combine all the workbooks in a folder. This code merge all the workbook in a folder names source folder. My issue is as of now this is only collate the Sheet named Data, and now sheets names...

While executing the following code I always get a message that "MS OFFICE EXCEL HAS STOPPED WORKING... ...... CHECK ONLINE FOR A SOLUTION...... CLOSE THE PROGRAM TO RESTART ......." Request to guide Private Sub cmdLogout_Click() ActiveWorkbook.Save ActiveWorkbook.Close...

Hi all & Happy New Year, Quite new to using VBA and facing a challenge. I have an Excel file with multiple sheets and the same structure, as below. I'm interested in working only in row 2 range Name A B C Status Created Hold Ready Date today today today What I want is to go in each...

I have an xml file that is about 80MB. I constantly have to import it in excel and do filtering in it. Sadly, it takes too long to open and sometimes crash. So I have decided to manually break it down into pieces. My steps are usually: 1-Use a software that split the files into multiple...

Good Morning All, i have written a macro that performsa task very well now i want to run a loop in a folder, i have 50 sheets in a folder and i have to open each sheet and then run the code , then it saved the Worksheet in a folder to go to next sheet i need to open another sheet and carry on...

Hi i have userform whereby when you select 2 different dates and name find, shows all the data for the matched person i was wondering if there is any easy way to show all multi sheets for same name between the 2 dates ranges shows all the matched person data into list box currently userform...

Hi, I have looked around the net, but I can't find a clear answer for the following. also a linked to excel is attached at the bottom I would like a VBA code that can fill up the cells, and continues filling not start from the begging so it is based on the current date for example if the...

Hello!, How can I get the value to populate into an email of row 1?. I can get row 2, 3 and so on, but since row 1 it Dynamic Serial number. If I copy "=Row() -1" into .Htmlbdoy it wont work. THanks

Hello, Can you guys help me with below requirement. I have a below formula which i need to put it a column by searching for a date in Row3. that date should be given as user input. let us say user gives the data as 10/24/2020 then the code needs look for the date in row 3 and if it is found in...

HI , Looking for ISBN (10 and 13) validation specifically for ISBN 13 so I can used on VBA Macros , I saw some ISBN 10 validation , but couldn't find proper one for ISBN 13 , the function I can used in VBA like the following : if fn_isValidISBN13('1234567890123') then 'do something end if...

:confused: I am trying to code a pop up when the user deletes "Pending" Column M. I have searched for samples where; entry was deleted & the message had Yes/No response. I have a previous message saying "Two appointments were scheduled on your calendar previously. The first appointment was a...

<tbody> A A B 3 C M D E GENBPAPP A 3 S GENBPAMIN A 1 SE SEBPA B 1 M GENLPA B 1 A GENLPA A 3 S CU CUAMIN </tbody> Hello, I have the above table (which I hope the format sticks around) as a lookup. I have rows of data that contain values. am looking for a formula or vb logic...

Every other cell on column "B" has the following letters, "LLC". My vba script should clear all "LLC" and horizontally delete entire ROW. However I keep getting a compile error, is this due to the reason that I have not selected a range? The code I have already used: :confused: Sub...

Cross Posted here: https://www.excelforum.com/excel-programming-vba-macros/1267176-copy-dynamic-range-to-a-sheet-in-new-workbook-with-specific-format.html#post5077492 Hi, You can see 2 sections in my attached excel file. Section-1 is the sheet in source workbook and Section-2 is the...

I have a worksheet that is used to make reservations for appointments in 1/5-hour increments. Occasionally a 1-hour slot is required, So, if a hour appointment is made, there is a second entry in these cell ranges B4:C10, B13:C17, E4:E10, E13:E17. I am trying to remove the second entry, &...

Hi, i have the below macro which removes values in column H when column I has a "Yes" in. is there a way to change this into an automatic VBA that runs in the background? Sub Remove_Column_H_Values()' ' Remove_Column_H_Values Macro ' ' Application.Goto Reference:="R7C9"...