I am tasked in work with creating a share-point site. Here are my requirements:
The main page must allow the user to create a new "File".
The file must be an excel sheet template that i will style to my liking.
After the user creates a new "File", the Excel sheet is opened in the webpage for them to edit. They can save it and reopen later.
Many other users will create new "files" also - same process - same template. If i change the template then any new files use the new template.
When files are created the user must put it into a section that high level describes the location of our plant that the "file" is relevant for . e.g Some users will put files under the "Company Shipping category" category and others the "Company receiving category".
Any user can search any or all "files" for full textual searches and also within categories of our company plant (as described in item Above)
Is all this possible and what is the easiest method - Any examples of this would be great.