auth

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

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Hello I would love any assistance on this, I've spent hours trying to solve this. Thank you in advance for taking any time to help. The result I would like I type in a name and date of...

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

Hello! the below code will successfully navigate to an intranet site, input a value into a form field, press submit button and follow a hyperlink. Where I'm getting stuck is to select a value from a drop down list (which is inserted in a table - not sure if that matters). Dim URL As String...

I'm trying to build a PivotTable that will show us how many total units each of our clients has in their authorizations, how many units have been used, and how many are left. Every two weeks our payer sends us an "Auth Dump" that includes the client ID, authorization ID #, service name, start...

Hi all - first post! Not sure how to word what I want but here goes. I have an excel spreadsheet that on one sheet records details of invoices and on another records authorisations to pay invoices. I want a cell to automatically search the Authorisation sheet for a row and ideally a...