Thread: Using hyperlink function on several cells at a time and countif

Hi,

I have 4 sellers with 4 different Excel-workbooks, and I have one workbook where I put the data from all my sellers to compare their results.

I would like my workbook to get all updates automatically, by using the hyperlink function. I am able to copy and make one hyperlink at the time, but not several... Is this possible?

And in the same workbook, I have used the countif function, but can I use the countif function to count cells which are not empty in a row? The cells I want to count contains company names, or they can be empty :-)

Thank you very much for helping!

See attached example, I would like to import data from salesman 1 to my workbook: