Hello,
I am in the middle of creating a bunch of macros and one thing I am stuck on is, how do I go about adding "Under Contract" in the Analyst Notes Column (T) when there is some form of data in the Vendor Contract Column (AD)? Not all thedata in Vendor Contract will be the same, its either blank or it has some contract code in the column and I need the ones that have a contract code to then enter the note in the Analyst Notes column.
Thanks!
I am in the middle of creating a bunch of macros and one thing I am stuck on is, how do I go about adding "Under Contract" in the Analyst Notes Column (T) when there is some form of data in the Vendor Contract Column (AD)? Not all thedata in Vendor Contract will be the same, its either blank or it has some contract code in the column and I need the ones that have a contract code to then enter the note in the Analyst Notes column.
Analyst Notes | Site Manager Notes | Corrections | SVC | Modality | EQStatus | Sub Status | InstalledDate | Ownership | WarrantyCode | VendorContract | VendorContractEnd |
$ 66,629.11 | BIOMED | Active | Owned | 2/15/2005 | TVC010919 | 11/30/2022 |
Thanks!