Link to file

[vpranitha]

Hi all,

I am looking to update value of cells based on unique file path, but different file names. See example below

File Path	File Name	Column Header 1	Column Header 2	Column Header 3
xxx	aaa	=file path/file name/tab/c1	=file path/file name/tab/d1	=file path/file name/tab/e1
xxx	bbb	=file path/file name/tab/c1	=file path/file name/tab/d1	=file path/file name/tab/e1
xxx	ccc	=file path/file name/tab/c1	=file path/file name/tab/d1	=file path/file name/tab/e1
xxx	ddd	=file path/file name/tab/c1	=file path/file name/tab/d1	=file path/file name/tab/c1

Can we find a function to accomplish this, where we update the file path and file name and the columns are updated when link is refreshed.

Thanks all for the assistance.