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