Excel N00b
New Member
- Joined
- Sep 7, 2017
- Messages
- 1
Greetings Excel Wizards,
I need help with some code.
I have a table. Its name is Table2.
The first column of the Table is in Column B and its header(B2) name is FILE#.
I'm looking for a way to have every entry (current and future) in the file column be automatically hyperlinked to a corresponding excel document with the same name as that cells contents in the file column. I would need it to check in 3 subfolders (all within the same parent folder)
The parent destination is C:\Users\Bob\Documents\WorkFiles
I'm new to VBA, and don't really speak code, but with your help I'd be able to implement this.
Please and thank you!
I need help with some code.
I have a table. Its name is Table2.
The first column of the Table is in Column B and its header(B2) name is FILE#.
I'm looking for a way to have every entry (current and future) in the file column be automatically hyperlinked to a corresponding excel document with the same name as that cells contents in the file column. I would need it to check in 3 subfolders (all within the same parent folder)
The parent destination is C:\Users\Bob\Documents\WorkFiles
I'm new to VBA, and don't really speak code, but with your help I'd be able to implement this.
Please and thank you!
