Save file based on cell value

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.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,123,177
Messages
5,600,160
Members
414,367
Latest member
dw970906

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top