Hi folks how are we all?
Im new to making spreadsheets.
I just started a new job as a Storeman at a company and im now trying to bend my head around spreadsheets, as ive never had to use them before.
I have already worked out some features of Calc, such as freezing a row so i dont lose my headings, setting up some data validity settings for various columns so that only data i specify can be added for instance…
I have several columns as follows :- Part Number, Supplier, Category, Product Description, Stores Location, Start amount, Current Amount, Reorder Amount, Cost(unit) and Stock Value.
I have also managed to work out how to add info to those data columns using a dropdown menu but that only works for some columns i.e supplier or category, but not for others that will require more input such as Product description!
However what I would like to do is set up a data entry form that is a totally seperate item that once you have filled out and pressed Enter, it will populate the spreadsheet with that info, as per the rules/formulae that are within the spreadsheet.
As an example, I have managed to use the top menu ‘Data>form’ to add info myself, however, it copies cell settings as you do so and populates my spreadsheet with the same font size and cell colour, which is no good…
I hope that makes sense and someone can offer some assistance…?
Thank you for reading.
Kind regards folks,
