Automatically insert Cell References from one Sheet into other Sheet in OOO Calc
- by user123456
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.
