Automatically insert cell references from one sheet into other in Calc

Posted by user123456 on Super User See other posts from Super User or by user123456
Published on 2010-04-11T11:21:39Z Indexed on 2010/04/12 0:33 UTC
Read the original article Hit count: 442

Filed under:
|
|

I have spreadsheets in OpenOffice.org Calc that consist of the first sheet and an arbitrary number of additional sheets, each collecting data for a specific month. The Month sheets have an identical structure. The first sheet is supposed to provide an overview to the most important numbers in the month sheets.

Whenever I add a Month sheet, I want it to appear automatically in the Overview sheet with the structure given below. So, for each Month sheet, copy or reference some of the cells into the Overview sheet:

{Referenced Sheet Name} | Fixed Header1 | Fixed Header2 | Fixed Header3
Fixed Label 1           | {CellRef 1}   | {CellRef 2}   | {CellRef 3}
Fixed Label 2           | {CellRef 4}   | {CellRef 5}   | {CellRef 6}

I know how do to this for just one sheet by hand, but I have no clue how to make Calc do this automatically for me.

Is it possible at all? Any help appreciated.

© Super User or respective owner

Related posts about openoffice.org

Related posts about calc