Copying cells between sheets in a workbook
 

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.

Copying cells between sheets in a workbook
 

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.

Copying cells between sheets in a workbook
 

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.