zakasnak
Active Member
- Joined
- Sep 21, 2005
- Messages
- 308
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
Hello, all!
It's been awhile since I've posted, but this one is challenging me.
I have a sheet with unique values for documents in column A, 10 char, header row 1. I would like to run a search on a network folder (S:\_FY2024) to see if the document has already been processed at least once (sometimes they can be processed more than once), which would show up as the unique value at the beginning of the file name. If the document number is found in the file directory, I would like for the macro to put a designator "Y" in the same row, col K.
I assume it will need to be VBA, but if a formula would work, I would be happy with that as well! :D
TIA for any help anyone can give me!
It's been awhile since I've posted, but this one is challenging me.
I have a sheet with unique values for documents in column A, 10 char, header row 1. I would like to run a search on a network folder (S:\_FY2024) to see if the document has already been processed at least once (sometimes they can be processed more than once), which would show up as the unique value at the beginning of the file name. If the document number is found in the file directory, I would like for the macro to put a designator "Y" in the same row, col K.
Document | Organization | Traveler | TANUM | Trip Name | Trip End | Total Cost | Days Waiting | Assigned? | Returned? | |
TV0001XXXX | ORGORG | Lname, Fname | TANUM0001XXXX | Trip Name | 4/26/2024 | $555.50 | 22 | TM |
I assume it will need to be VBA, but if a formula would work, I would be happy with that as well! :D
TIA for any help anyone can give me!