fangfacekitty
Board Regular
- Joined
- Jul 28, 2010
- Messages
- 63
Is there a way that when saving a file the file name will automatically become whatever value is in a specific cell?
For example cell B3 in a form will be the item number. When the user saves the file I would like the file name to automatically save as whatever is typed into cell B3.
Item numbers are unique, no duplicates.
But users have the habit of using different variations so I will have multiple files for the same item number, i.e. 12345 AA, 12345AA, 12345-AA, etc.
Users will not be the ones entering a value in cell B3. Users make other entries in the file to save and that is where the file duplication starts, as each user saves a copy.
For example cell B3 in a form will be the item number. When the user saves the file I would like the file name to automatically save as whatever is typed into cell B3.
Item numbers are unique, no duplicates.
But users have the habit of using different variations so I will have multiple files for the same item number, i.e. 12345 AA, 12345AA, 12345-AA, etc.
Users will not be the ones entering a value in cell B3. Users make other entries in the file to save and that is where the file duplication starts, as each user saves a copy.
