authority

Hi All, I am using the code below to lookup a value from a Table. Private Sub Worksheet_Change(ByVal Target As Range) Dim LU As String Dim Auth As Variant Dim LU2 As String Dim Tbl As ListObject Dim Rng As Variant Dim Rng2 As Variant Dim FT As Variant Set Tbl =...

I am working on a spreadsheet to list people authorised to travel with IT abroad). I am trying to work on a section detailing those whose authority expires in the next 30 days Column A is the unique identifier Column B is the days to expiry of authority. rows B4-B5000 will contain the data My...

Hi All, In Column D of a sheet I enter a Charge Reference, for example CL12346. This relates to an Authority which I put in Column I. What I would like to do is everytime i enter a new reference it will put the appropriate Authority in Column I. I have worked out the code for the Lookup...