General discussion

Locked

Excel worksheet linking

By becky.hicks ·
I have a worksheet set-up as a template that I have linked to a separate spreadsheet to maintain the input info from the template.
I will use the template over-and-over without saving however I want to maintain a running list of the info.
In otherwords I need the 2nd template to appear on the next spreadsheet line and so on.
Help!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel worksheet linking

by DFowler In reply to Excel worksheet linking

Before posting an answer, I want to be sure I understand what you are trying to do. You want the information from the template to feed to a 2nd spreadsheet that will act as a database for the information entered through the template, with each use of the template resulting in a row of data added to the 2nd spreadsheet? If this is correct, would you mind giving an idea as to the type data/quantity of data you are going to be entering?

Collapse -

Excel worksheet linking

by becky.hicks In reply to Excel worksheet linking

Poster rated this answer

Collapse -

Excel worksheet linking

by Lo In reply to Excel worksheet linking

Hi - A clarification question also. Rather than saying what you are doing in excell, might indicate what you are trying to accomplish, such as: Create an Excel spread sheet that will allow input by a user but prevent the user from being able to modify data entered in previous session, or by other users.

While your current implementation may be exactly what you end up with, know what you are trying to accomplish may provide a better solution.

Collapse -

Excel worksheet linking

by becky.hicks In reply to Excel worksheet linking

Whether it is what I am trying to accomplish or what I am trying to do is not the issue.

Collapse -

Excel worksheet linking

by becky.hicks In reply to Excel worksheet linking

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums