test2

Hi All I would like to convert a list of military time in Column C to regular time in a different time zone (+3hr) and also deduct 45 minutes off the new calculated time. <tbody> Scedule Title Description Time Test1 Apple 620 Test2 Banana 1050 Test3 Orange 2015 </tbody> After...

Const test1 As Single = numero + 500 Const test2 As Single = numero + 800 MsgBox (test1 = test2) It display "False" although test1 and test2 both are shown as "2,147484E+09" in Locals Window. How can I see the complete content of test1 and test2? (eg. in binary code)

Hi. I have a userform, with two textboxes, and a button. The button enters the values (text and numbers) from the textbox to cells. Example: Textbox1 and textbox 2. If i write 1A in txbox 1 and 2A in txbox 2, then it enters that value in A2, and B2, then if i type new values, it goes in A3 and...

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...

Hi, I have question on VBA Vlookup code. I need to vlookup Test1 A column TO Test2 & Test3 files. Test2 & Test3 have same format, and vlookup should be like below =vlookup(TEST1 Column A values, test2 & test3 A:B,2,false) please help! Thanks in advance!!

Hi I am trying to search a data within a table and return the header of the corresponding column. For example, <tbody> A B 1 Test1 Test2 2 12 17 3 13 18 4 14 19 5 15 20 6 7 18 B </tbody> If cell A7 = 18, then cell B7 = Test2 If cell A7 = 15...

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...

Hi All, I was wondering if there's a method to achieve the following. I work with a large number of externally provided fixed format workbooks. From all those workbooks I need a number of values which are in the same exact cells. See table below for an example of what I would like to achieve...