ExcelBanter - Copy data in multiple worksheets

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Copy data in multiple worksheets (https://www.excelbanter.com/new-users-excel/104388-copy-data-multiple-worksheets.html)

kfletchb

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

Mark

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

kfletchb

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

All times are GMT +1. The time now is 03:46 AM.