Automatically insert Cell References from one Sheet into other Sheet in OOO 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/11 11:23 UTC
Read the original article Hit count: 460

Filed under:
|
|

I have a spreadsheet in Open Office 3.0 Calc.

The spreadsheets 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.

What I would like to do is this:

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 OOO do this automatically for me. Is it possible at all? Any help appreciated. Thanks.

© Super User or respective owner

Related posts about openoffice.org

Related posts about calc