How do I print a filename at the end of the file (not every page)

I know how to print a dynamic file name in a footer but that doesn't solve my
issue. I can't find an option to print footers just at the end of a file. I
can't find a function like the date/time where you can insert a dynamic file
name in a cell.

=CELL("filename")

Returns the filename of the spreadsheet and the path. Not sure if that helps

Regards

Dav

=CELL("filename",A1)


"sanfranson" wrote:

> I know how to print a dynamic file name in a footer but that doesn't solve my
> issue. I can't find an option to print footers just at the end of a file. I
> can't find a function like the date/time where you can insert a dynamic file
> name in a cell.