(Msg. 1) Posted: Thu Nov 20, 2008 11:20 pm
Post subject: Copying cells between sheets in a workbook Archived from groups: microsoft>public>excel>misc (more info?)
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.
(Msg. 2) Posted: Fri Nov 21, 2008 1:11 am
Post subject: RE: Copying cells between sheets in a workbook [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 3) Posted: Fri Nov 21, 2008 5:55 am
Post subject: RE: Copying cells between sheets in a workbook [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office