Hi,

I have a simple concept, but I'm sure it requires a complex string of functions/coding. So here's what I am trying to do:

Let's say four columns: A, B, C, D

Column A will be used for hyperlinks added at any given time

Column B will reference and copy text located in a specific cell within the hyperlink provided in column A

Column C will reference and copy a date located in a specific cell within the hyperlink provided in column A

Column D will reference and provide the average of five specific cells within the hyperlink provided in column A

Functions in B1, C1, and D1 should reference hyperlink in A1; B2, C2, and D2 reference hyperlink provided in A2, and so on.

What I need is a function or functions that will leave columns B, C, and D empty until a hyperlink is provided in A, and then they carry out their respective functions referencing the specified cells within the hyperlink that gets put into column A. The only way I can think to describe this in non-technical terms is having placeholders in an IF function that get replaced by whatever hyperlink gets entered into the A column (where "x" equals the contents of column A: B1=IF(x=,,=SUM([column A hyperlink]Sheet1!B14)) ). I know that that isn't a proper formula, but hopefully it helps illustrate what I am trying to do. I want the formulas to be present at all times so that it does the work automatically when a user enters a hyperlink into column A (rather than having to write the functions for the respective cells each time a hyperlink is inserted). I know how to logically form a formula string, but I'm not familiar enough with Excel or the functions within the program to write this formula myself (if it's even possible to do so). I've been looking at the TEXT functions REPLACE and SUBSTITUTE, but I don't know if those have anything to do with what I would like to do. If anyone is able to provide some help, I will be eternally grateful; I have the will, I just need help finding the way! Thank you!

Dustin