Question for my more tech savvy friends. I have spent nearly an hour googling this and haven't found the answer (that I know of). I'm trying to make a table that references files on our sharepoint. This is supposed to be a log that summarizes reports that are saved on sharepoint, we use a standardized file naming structure, so the fields in the log can be used to determine the URL (and I have a formula that automatically makes the URL). What I'm trying to do is make that column a hidden column and instead have a hyperlink that essentially says "click here". I've tried making a macro that would do that, but even using the "use relative reference" setting on the macro recorder (I don't even know how to begin on VBA, that is what I've been googling with no luck), but it always just creates a hyperlink to whatever I did for the first row.
Any ideas on how to get past this is definitely appreciated.
Any ideas on how to get past this is definitely appreciated.
Comment