Okay, here's a weird one:
It would speed things up, as well as solve accuracy issues if I could have certain cells in my workbook linked to its actual filename. I attached my example workbook to help clarify:
The Data Entry Page is the sheet I'll need to modify. This workbook is a blank, which gets 'saved as' to a name like '123456-7 REV08' So then, it would be great if upon opening it, Cell B9:G9 would display the group of digits before the 'space', in this example '123456-7', and Cell B11:C11 would display the group after - '08'.
Can this be done?!![]()
Bookmarks