Ask Your Question

Is there a way I can preload a list of client names so that I don't have to enter them for each spreadsheet?

asked 2017-01-30 23:21:39 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Every time I go to a new spreadsheet I have to re-enter the names of each of my clients. Is there a way that I can create a list of clients that will be available from every spreadsheet? I do use a template so is it possible to add them to the template?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-01-31 02:57:26 +0100

robleyd gravatar image

updated 2017-01-31 02:58:33 +0100

A few, of doubtless many, possibilities, depending on how the client names are used.

  1. Add them to your template; this means of course that each time your clientele changes you have to edit the template.
  2. If having the client list on a separate sheet works, you could create a separate spreadsheet file with the client list on it - which can be edited as required - and add it to your current spreadsheet via Insert | Sheet From File
  3. Insert | Link to External Data to an external spreadsheet which can be edited as required
edit flag offensive delete link more

answered 2017-01-31 20:50:04 +0100

billp gravatar image

I haven't explained myself clearly. I do a spreadsheet every month and my clients vary every month. Currently I enter a client name once and then I don't need to enter that name again for that sheet because it automatically gets expanded. I would like to preload those names for a sheet so that I only have to start typing the name before it is automatically filled in.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-30 23:21:39 +0100

Seen: 43 times

Last updated: Jan 31 '17