Hi all, Im trying to create a fully automated document tracking index.
I have 2 sheets
Sheet 1 (Items in columns A, C, D are hyperlinked to pdf files):
<tbody>
</tbody>
Sheet 2:
<tbody>
</tbody>
I have got the items in column A (no hyperlinks req'd), but I cant get the Rev columns to come over with hyperlinks.
The Rev columns in sheet 2 may contain letters and numbers and continue indefinitely.
I have exhausted my knowledge in vba I think, and Im going to need some help.
Thanks in advance
Sleekgeek
I have 2 sheets
Sheet 1 (Items in columns A, C, D are hyperlinked to pdf files):
File Name | Date | Drawing Number | Rev |
025510-011_D.pdf | 2/5/2011 | 025510-011 | A |
025510-100_A.pdf | 17/11/2011 | 025510-100 | A |
025510-100_B.pdf | 18/11/2011 | 025510-100 | B |
<tbody>
</tbody>
Sheet 2:
Drawing Number | Rev | Rev | |
02510-011 | A | ||
02510-100 | A | B | |
<tbody>
</tbody>
I have got the items in column A (no hyperlinks req'd), but I cant get the Rev columns to come over with hyperlinks.
The Rev columns in sheet 2 may contain letters and numbers and continue indefinitely.
I have exhausted my knowledge in vba I think, and Im going to need some help.
Thanks in advance
Sleekgeek