| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying data to multiple worksheets by Macro | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| macro to copy multiple rows to separate worksheets | Excel Worksheet Functions | |||
| Link Data from Multiple Worksheets | Excel Worksheet Functions | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
