Ask Your Question
1

Calc: Synchronize Cells? [closed]

asked 2013-03-05 23:09:45 +0100

Bastian gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 20:10:43.643023

3 Answers

Sort by » oldest newest most voted
0

answered 2013-03-28 08:13:04 +0100

ROSt52 gravatar image

@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.

edit flag offensive delete link more
0

answered 2013-03-06 03:37:53 +0100

ROSt52 gravatar image

@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

edit flag offensive delete link more

Comments

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 gravatar imageBastian ( 2013-03-16 11:35:12 +0100 )edit

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 gravatar imageBastian ( 2013-03-16 11:48:01 +0100 )edit

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.

Bastian gravatar imageBastian ( 2013-03-16 11:49:34 +0100 )edit
0

answered 2013-03-06 00:43:14 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-03-05 23:09:45 +0100

Seen: 563 times

Last updated: Mar 28 '13