vba matching

Hi folks! I'm having troubles figuring out a way to move data from multiple columns (that are not text to each other) based on a different column that is being compared to yet another column: The file that I'm using has over 12k rows and what I'm aiming to do is get the data from columns A and...

Hi. I have a difficult one for you all. I'm trying to translate some data to different columns in VBA based on some complex criteria. Not sure on the formatting to search this stuff so hopefully someone can help ! :) What I would like to do is feed in raw data ID's under Name/Desc/Type in F...

ThisWorkbook.Sheets("Sheet1").Activate Range("Sheet2!F8") = Application.Sum(Application.Index(Range("A:MN"), 0, Application.Match("Jack", Range("A2:MN2"), 0))) End Sub I have been working with a excel file with lot a data. So I have comeup with a VBA code(mentioned above) this will look...

Hi Guys, I have an issue that i would like to solve. Have been looking on the internet but haven't been able to find anything that does the trick exactly. To form the picture of the problem: I have a program that runs a query search for me, it gives me back the description and url of a page. I...

Hello I'm trying to remove the potential of people messing up a database I've created when adding new employee details. This this end I've added a 'front page' type of set up that allows users to perform certain functions and will protect my database from user error. Here is a miniature version...

Hi I need help, I am still a relative newbie as far as VBA is concerned, so any advice would be well received. I would like some code which will look at and cross check only integer values in columns A & B and where a match is found to enter a unique and incremental numerical value without...