1. V

    VBA CODE EDITING - Search and Match and show the result

    Hi all, We are using the following VBA code Sub Search_and_Match() Dim sh1 As Worksheet, sh2 As Worksheet Dim lr As Long, lc As Long, col As Long, lr2 As Long Dim c As Range, f As Range, r As Range ' Set sh1 = Sheets("Sheet1") Set sh2 = Sheets("Sheet2") lr = sh1.Range("A" &...
  2. P

    Convert the order the first and last name is written via formula

    Hi assuming I have "Driver Name: Donald Williams Jr" in Cell A1 in B1 I am looking formula that will show "Williams Jr, Donald" ...not sure if that is possible so the other option is in B1 have just "Donald Williams Jr" then in C1 "Williams Jr, Donald" thanks for the help.
  3. F

    VBA: Split string between two words to extract sub string

    I have a sting and the code below works find to return the name. I just don't understand what the numbers in the parenthesis are doing? DEMOGRAPHICS NAME: Donald J. Duck BANK: 451CS Sub trythis() Dim MyText As String MyText = Trim(Split(Split(Range("A1"), "NAME: ")(1), "BANK:")(0))...
  4. masud8956

    Finding values between two dates from specific entries

    Hi Experts! I have a project like this: <tbody> A B C D E F G H I J K L M N O P Q R S T 1 2 3 START DATE 1 JAN 18 4 END DATE 2 JAN 18...
  5. A

    Number data in a column based on its uniquness

    Hello Everyone, I think my question / problem is simple but since i am still learning I need your help. I have 2 columns (ColA,ColB) ColA = Random volume of rows with some data which repeats frequently. ColB= should pick up a sequential number 1,2,3,4 for every new data in ColA. If a data...
  6. T

    Count Unique with on multiple If

    I need a unique count of users within each week. Sample Data: <tbody> Date Name Week Number Sum of Unique Count of users each week (Need Formula for this one) Expected RESULT 2/1/2017 Donald 5 3 2/1/2017 Goofy 5 3 2/1/2017 Minnie 5 3 2/2/2017 Donald 5 3 2/2/2017 Minnie 5 3...
  7. G

    Compile data

    Hi, Im having a problem where I want to compile data from several rows into 1 single row. The data in this case is time and attendance data to upload into a payroll software. There are 9 different columns as follows: Code Code nr Code name Employee ID Employee name Number (hours/days) Type...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...