Hi Everyone.
I've recently created my first what i'd call 'complex' spreadsheet. It's for my girlfriend's fashion business. She needs to order fabric to make clothes from based on how many metres of each fabric each garment uses, and then based on the quantity of orders she receives for them.
I've got a few questions, however.
I have a few "Names" for cell validation, however when I need to add a fabric type to this column, I then need to expand the Name to include that new fabric. Is there a way this can be updated automatically?
Also, is it possible to make parts of the spreadsheet uneditable?
And, the last, and probably most complex thing. How do I make it so she can add or delete rows using a button. When adding, it inherits the formulas of the row above it. - All the totals that read from these rows also need to self-update.
Probably a big ask, but even if you could point me in the right direction, i'm happy to research.
Thanks!
Bookmarks