I’m trying to create an inventory workbook. Sheet 1 (call it “master”) is where sums of values would all display by using links. Sheet 1, column A, is the item description and is unique. There will be 5 additional sheets representing sales locations. All locations sell the same inventory item mix. Today there are 749 items.
Sometimes a new item is added, it is added by inserting a new row between two existing rows and a new item description is typed into column A. I want Calc to auto-insert the same line, in the same location, in all the other 5 sheets and display the new typed description.
Is this possible? How do I make it happen?
Thank you in advance for any help or advice!