Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

Excel > Calling up "snippets" (something like that) - a paste "file" of commonly used text ...

Hi,

I do invoices in excel.

Is there any way to have a bit of excel remember snippets of commonly used text

for example a bare metal install invoice ........

Copy data
restored windows
installed updates
Restored data

I dont want to have to type this every time.

Aside from having a notepad of these is there a way to call this into excel?
Is there an inbuilt notepad in excel for the likes of this?

Thanks,
0
fcek
Asked:
fcek
  • 4
1 Solution
 
Martin LissOlder than dirtCommented:
You could easily have a hidden sheet where the snippets would reside. Put each one in a single cell and use the Name Manager to give them names that you can use. Then you could do something like

Range("A1").Value = Range("BareMetal").Value ' "BareMetal" is the named range.
0
 
Martin LissOlder than dirtCommented:
Actually

Range("A1").Value = Sheets("MyHiddenSheetName").Range("BareMetal").Value

Or, if this is for your personal use, forget about hiding the sheet and the named ranges, just copy and paste the values from the formerly hidden sheet.
0
 
Martin LissOlder than dirtCommented:
Did that help?
0
 
fcekAuthor Commented:
Thanks
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now