I am trying to gather data from a number of other excel files, I want to piece the file reference name together from other pieces of information - in a CONCATENATE way if you like, getting the network address from here - file name from there etc..
However, when I do this, I then need to copy and paste special value, from the CONCATENATE formula, then enter the cell and press return again before it actually becomes automatic - any help please ?!
However, when I do this, I then need to copy and paste special value, from the CONCATENATE formula, then enter the cell and press return again before it actually becomes automatic - any help please ?!