test3

I'd like to set up a sub to call another sub based on a value in a cell, rather than calling a specific pre-defined sub. For example: Sub test1() x = Worksheets("Sheet1").Range("B2").Value Call x End Sub Sub test2() Worksheets("Sheet1").Range("B4").Value = "test2 has run" End Sub Sub...

Hi all, Have a simple Table1 where in column C are Dates, in column D Status, and Column E Update. What I wish for is that when a cell in Column E changes its value (it's data validation list) to do this: Add value of cell to cell in column C (simple C.value=C.value+E.value*7) Check if E.value...

Hey everyone, I was working on a project in excel where I have 9 columns of dates. They each column represent a milestone in a project (it's kind of a scheduler). I want to make a pivot table that makes it so I can see all the milestone dates. Currently this is impossible as they are in 9...

Hi Team,:confused: I want to apply a vlook up formula, but it will not work, as in my vlookup formula LastName has come first and First name as last. and in mydata its opposite. I come cross such type of scenerio in office and manually update Teams score. Can you plz suggest a excel formula...