I am composing Excel document with my task-tables. It contains tasks, divided over several scopes. Tasks from every scope should be displayed in separate sheet. In every sheet, associated with a scope, would be a task-table with the same columns and format as other's scopes tables.
So I want to have a tamplate of such table, from which would be generated table headers and fetched column properties. I want to have only one place where i can change table's header style or column properties, and they would be applied to all task tables.
So the question is:
- Is there functionality in excel to share entire rows through sheets?
- Is there a way to copy cells or columns format (and other properties) using cells formulas?
- In which way i can make a sheet, that aggregates rows from all sheets in one table?
It would be greate to have scripts or documents examples.