I do 12 months of financial statements and want to setup one sheet and copy
it to all other sheets Jan - Dec so that I have expense catagories consistant
from month to month and link cells from month to month to tabulate yearly
totals. I use another prorgam for this which is pretty simple but would like
to do this in Excel for the new year if I can figure it out.

To set up all worksheets with the same headers and formatting insert 12
worksheets and select them all (using shift-click). Then whatever you do in
one of the worksheets is replicated on all sheets.

To link cells from different worksheets (for example in worksheet 'Jan' cell
'A1' use =Jan!A1

(note the "!" indicates a worksheet reference)

"Rick" wrote:

> I do 12 months of financial statements and want to setup one sheet and copy
> it to all other sheets Jan - Dec so that I have expense catagories consistant
> from month to month and link cells from month to month to tabulate yearly
> totals. I use another prorgam for this which is pretty simple but would like
> to do this in Excel for the new year if I can figure it out.

Thanks, that partialy answers what I'm looking for. Let me phrase the
question a different way. How can I type something say a catagory "office
supplies" on one sheet and have it copy to all the other sheets in the
workbook?

"phildy" wrote:

> To set up all worksheets with the same headers and formatting insert 12
> worksheets and select them all (using shift-click). Then whatever you do in
> one of the worksheets is replicated on all sheets.
>
> To link cells from different worksheets (for example in worksheet 'Jan' cell
> 'A1' use =Jan!A1
>
> (note the "!" indicates a worksheet reference)
>
> "Rick" wrote:
>
> > I do 12 months of financial statements and want to setup one sheet and copy
> > it to all other sheets Jan - Dec so that I have expense catagories consistant
> > from month to month and link cells from month to month to tabulate yearly
> > totals. I use another prorgam for this which is pretty simple but would like
> > to do this in Excel for the new year if I can figure it out.