Copy data in multiple worksheets

K

kfletchb

How do I put the total of a row(column) of numbers from one worksheet to
another worksheet?
Mahalo.
Karen
 
M

Mark

kfletchb said:
How do I put the total of a row(column) of numbers from one worksheet to
another worksheet?
Mahalo.
Karen
Click to expand...

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
 
K

kfletchb

great. thanx mark

Mark said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
VBA Coding Help for Beginner 0
Newbie Help 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Help with cell referencing. 0
Need Help with a VBA subroutine 0
Macro to Run Functions and VBA code??? 0
How can I copy data produced by a formula, not the formula? 2

Top