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: 493
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