match and add

(?<word> \w{4,}) This is a php code that does exactly what I want my macro to do. String together characters a-z and 0-9 (not case sensitive) and match words when they are equal to or greater than 4 characters. I am not sure how to get this code into VBA's language. I need it to loop through a...

<tbody> 1489534983 -36 -41 -31 -37 1489534983 -38 -43 -32 -36 1489534983 -38 -41 -30 -37 1489534983 -36 -43 -32 -36 1489534984 -36 -41 -32 -37 1489534984 -36 -41 -32 -37 1489534984 -36 -41 -32 -37 1489534984 -36 -41 -32 -37 1489534985 -36 -41 -32 -37 1489534985 -36 -41 -32 -37...

Hi guys, I really need your help with my project, because i am stuck.. first, here is the link to my example file: https://www.dropbox.com/s/9vkh8y5w30le6r2/Map1.xlsx?dl=0 What i want to accomplish is. (just write it down what is logical for me tho:smile:) 1st issue: with...

Excel 2010: I’m working with a sheet where I would like to get accurate results on the make and model of cars sold in a given week. The workbook contains several worksheets each representing weekly sales numbers for different vehicles. The Make-Models tab has the lists used to create the...

Hi everyone, I would appreciate it if someone can help me with this. I have a workbook of 13 sheets. All 13 sheets contain the same information:Activity-Employee Code-Employee Name-Code1-Cost1-Code2-Cost2. I'll show a small example to illustrate my case: I have a table containing all...

Here is what I am trying to do, I have a list of employees, grouped into teams, each team between 10- 25 employee. Each team member have to achieve certain goals and he/she will be ranked accordingly, the ranking assumed as percentage between -100% to 100%. There are 9 goals each employee have...

Ok, firstly i have no experience with macro much or vba. we have many spreadsheets; now rather than copy pasting.. surely if the headings match.. then a formula should be able to copy the data underneath into the master sheet automatically or with less effort with index/match, hlookup or...

HELLO EXCEL fans & pro's i have a have a matrix in a separate sheet a9:bb70 [where columns c9:bb9 are the 52 weeks of the year] each row [9 to 70] represents totals [hours] of a particular project in any of the 52 weeks i have another sheet where a user can select a period of time [start...

Notes: Not all cells have contents. The list on Provider_Info! is dynamic (additional rows and information will be added). The location in Provider_Info! needs to correspond (match) the location in Financial_Summary! and sum $ of Refund Received in corresponding year. Example: Contents of...

The setup column b S S S D D S S S D D D D column b is the column I get my values from a1 would be a helper column that's numeric that indicates days Column a 1 2 3 4 5 6 7 8 9 10 11 12 I need a formula that will tell me how many times the S REPEATED 3 times REFERENCE TO column...

Hi, I am at below zero level when it comes to VBA so what you see is a recorded macro, which I failed to complete. What this macro is supposed to do, is to search within given row (say Row7) for given value and when match (find) occurs, value at offset of 1 column is to be taken and added to the...