Calc: Synchronize Cells?

[Bastian]

Hello,

I have created a long detailed Timetable in Calc. Now I want to make a Summary version of the timetable containing only key items from the timetable. I want to be able to change the values in cells in both the Summary version and the detailed Timetable and I want Calc to keep the values in synchronization with each other. If the value is updated in one, the change should be reflected in the other. Is this possible?

The closest I have got is by using “Link”, but I can only change values in the detailed Timetable that way, not in the Summary Timetable. Help is appreciated!

[mariosv]

I do not know what kind of summary do you want?.
But I think a filter can help to achieve the result.
The filter hide not wanted rows, without deleting, but allow modify the visible rows.
Menu/Data/Filter, it is better define the data range in Menu/Data/Define range.
And Menu/Data/Subtotal to do summary operations on the data.

[ROSt53]

@Bastian
Sorry but I don’t understand what you want to achieve. Already

Summary version of the timetable containing only key items from the timetable

is not clear to me.

I gave you some karma so you can upload files, even scanned pencil sketches would be helpful

[Bastian]

I am making a timetable for an upcoming local film festival. I have two datasheets. The first datasheet looks like this: http://i.imgur.com/LDV4noS.png - It shows the categories and everything the categories must contain. The E column contains the time each category will take in total and the time in column B updates when I update the timetable. My job is to keep these numbers up to date so we can see whether we are over-schedule or not.

[Bastian]

However, the timetable is in its full size is very huge, so I wanted to create a summary of that timetable like this: http://i.imgur.com/k9lbSPt.png - It is much easier for me to get an overview this way, but I need column E in the first datasheet and column D in the second datasheet to contain the same values at all time. Linking is possible, but then I can only update values in one of the datasheets. I want to be able to update the values in both datasheets. How can I do this?

[Bastian]

Oh and how do you upload files here? I had to upload to imgur.com because I couldn’t find any place to do attachments.

[ROSt53]

@Bastian

I had a look at the examples you showed.

Idea 1: Filter on columns like A or B for “not empty” and print what you see

Idea 2: Create a second sheet and link all cells in rows which are not empty in A or B, The new sheet would be your summary sheet.