ExcelBanter - Insert a filename that will automatically update if changed.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Insert a filename that will automatically update if changed. (https://www.excelbanter.com/excel-worksheet-functions/210588-insert-filename-will-automatically-update-if-changed.html)

Insert a filename that will automatically update if changed.

I have temporary file names that I need to enter into Excel, but I know later
on they will change. Is there any way to automate this so that when the files
are renamed the spreadsheet will automatically update?

This would be very helpful.
Thanks,

JE McGimpsey

Insert a filename that will automatically update if changed.

See

http://mcgimpsey.com/excel/formulae/cell_function.html

In article ,
JR wrote:

I have temporary file names that I need to enter into Excel, but I know later
on they will change. Is there any way to automate this so that when the files
are renamed the spreadsheet will automatically update?

This would be very helpful.
Thanks,

All times are GMT +1. The time now is 06:46 AM.