Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel New Users
Copy data in multiple worksheets
Forums
Newsgroups
Microsoft Excel
Microsoft Excel New Users
Copy data in multiple worksheets
 |
Copy data in multiple worksheets |
|
|
Thread Tools | Rate Thread |
10-08-2006, 11:10 PM
|
#1 |
|
Guest
Posts: n/a
|
Copy data in multiple worksheets
How do I put the total of a row(column) of numbers from one worksheet to
another worksheet? Mahalo. Karen |
|
|
10-08-2006, 11:28 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Copy data in multiple worksheets
kfletchb wrote: > How do I put the total of a row(column) of numbers from one worksheet to > another worksheet? > Mahalo. > Karen Use something like this: =SUM(Sheet1!B1:B25) Change the value "Sheet1" to the name of your worksheet Change the value "B1:B25" to the cells that you are adding DON'T FORGET THE EXCLAIMATION POINT AFTER THE WORKSHEET NAME |
|
|
|
11-08-2006, 01:18 AM
|
#3 |
|
Guest
Posts: n/a
|
Re: Copy data in multiple worksheets
great. thanx mark
"Mark" wrote: > > kfletchb wrote: > > How do I put the total of a row(column) of numbers from one worksheet to > > another worksheet? > > Mahalo. > > Karen > > Use something like this: > > =SUM(Sheet1!B1:B25) > > Change the value "Sheet1" to the name of your worksheet > Change the value "B1:B25" to the cells that you are adding > DON'T FORGET THE EXCLAIMATION POINT AFTER THE WORKSHEET NAME > > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
