Good afternoon,
I have a sharepoint site that several users store the same template file on. Each in a different folder, sub folder, file name; however each with the same structure.
Is there a way to allow a user to select the file in a file picker, and save that as a variable or in cell that I could then reference in further code?
I would like each user to be able to select ‘their file’ then I use a basic formula to show the contents of that cell, (cell A205) on this sheet.
Making individual files all day for each separate user is intensive specially if the remote file changes once a year etc.
Thabks
I have a sharepoint site that several users store the same template file on. Each in a different folder, sub folder, file name; however each with the same structure.
Is there a way to allow a user to select the file in a file picker, and save that as a variable or in cell that I could then reference in further code?
I would like each user to be able to select ‘their file’ then I use a basic formula to show the contents of that cell, (cell A205) on this sheet.
Making individual files all day for each separate user is intensive specially if the remote file changes once a year etc.
Thabks