I am trying to use a concatenate statement that is currently working fine, but i would like to have the capability for dynamic changes in columns
=CONCATENATE('http://internet.com/workload/Spreadsheets/Team/[John Smith.xls]John Smith!G109," : ",'http://internet.com/
Instead of hard coding the name into the statement, i would like it to read whatever name i place in the cell
=CONCATENATE('http://internet.com/workload/
Spreadsheets/Team/[(C2).xls] ," : ",'http://internet.com/
That way we dont have to replace the statement every time, we can just add a column with a name whenever we add the corresponding spreadsheet.
Any Ideas?
Bookmarks