We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is it possible in Calc to link 2 or more sheets to one column of row values so inserting a new row in sheet 1 would also insert the same new row in all the linked sheets? [closed]

asked 2017-09-27 03:20:17 +0200

updated 2021-06-30 11:50:21 +0200

Alex Kemp gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-16 13:34:43.190694

1 Answer

Sort by » oldest newest most voted

answered 2017-09-27 09:44:25 +0200

Regina gravatar image

You only need to select all five sheets before inserting the row. Than it will be inserted into the sheets simultaneously. To select several sheet you can use the tabs at the bottom of the window. Use shift+click for a range of sheets or Ctrl-click to add a sheet to the already made selection. Or you use the dialog Select sheets… from the menu Sheet.

If you need to add the same content at the same cell position in several sheets, that is possible too by first selecting these sheets.

Click into the free area at the right side of the tabs to exit this selection mode.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-09-27 03:20:17 +0200

Seen: 110 times

Last updated: Sep 27 '17