login about faq

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's gravatar image

Beyond_Life
1.4k414874


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's gravatar image

DW96
1.1k81727

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's gravatar image

AlexMVP
1.2k61127

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's gravatar image

Beyond_Life
1.4k414874

To bad, but thanks for answering!

link

answered Jul 11 '11 at 02:40

Beyond_Life's gravatar image

Beyond_Life
1.4k414874

Your answer
toggle preview

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

Tags:

×16
×15
×1

Asked: Jul 06 '11 at 14:03

Seen: 2,394 times

Last updated: Jul 11 '11 at 02:40

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact