How-to assing cells in Excel to correspond with file name?

My dad wants me to make him a excel sheet with all different formula's in it. No problem, I can make those. But in the sheet, the first cells are used for a name from his client, and the second cell is used for a date.

Q: Is it possible to make Excel use those to cells to create the filename of the sheet when it saves?

asked Jul 06 '11 at 14:03

Beyond_Life ♦
1.3k●35●41●66

4 Answers:

oldest newest most voted

1	The answer would simply be No. I think there was some kind of trick that allowed you to save a document with the name of the first sheet, but hell if I remember how it worked... link answered Jul 11 '11 at 02:33 DW96 958●6●14●23

0	No freakin idea however, you can give cells a shortcut name so you can refer to them in formulas vs. using A8 etc... link answered Jul 06 '11 at 23:40 AlexMVP 1.1k●5●10●24

Well, the idea is that whatever I put in the first two cells, is used by Excel to create the filename. If im correct, Notepad did that in the early days. Picking the first words from the document and then autosave it with those words.

link

answered Jul 07 '11 at 03:38

Beyond_Life ♦
1.3k●35●41●66

0	To bad, but thanks for answering! link answered Jul 11 '11 at 02:40 Beyond_Life ♦ 1.3k●35●41●66

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or __italic__
**bold** or __bold__
link:
[text](http://url.com/ "title")
image:
![alt text](/path/img.jpg "title")
numbered list:
1. Foo
2. Bar
Code:
- Within a paragraph:
  `code`
  surround code with grave accents (backticks)
- Code snippet:
  Select the text and use the button on the icon of zeros and ones
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

excel ×15
office ×15
filename ×1

Asked: Jul 06 '11 at 14:03

Seen: 1,571 times

Last updated: Jul 11 '11 at 02:40

How-to assing cells in Excel to correspond with file name?

Follow this question

Related questions