ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   WORKSHEET INSIDE A WORK BOOK (https://www.excelbanter.com/excel-worksheet-functions/217186-worksheet-inside-work-book.html)

Larry

WORKSHEET INSIDE A WORK BOOK
 
I'M NEW AT THIS AND NEED SOME HELP. I'VE MADE A WORK BOOK THAT HAS 13 SHEETS
IN IT. I WOULD LIKE TO TAKE THE TOTAL FOR ONE LINE AND ADD IT TO THE LAST
WORKSHEET TO SEE THE GRAND TOTAL FOR EACH SHEET. CAN I DO THIS. FOR EXAMPLE
IF SHEET ONE HAS 10 COLUMNS AS I INPUT THE INFORMATION I WOULD LIKE THE TOTAL
FOR EACH COLUMN TO BE ENTERED INTO THE CELL ON THE LAST WORK SHEET. PLEASE
HELP ME!!!!!!!!!!

Pete_UK

WORKSHEET INSIDE A WORK BOOK
 
First of all, do not post using only capitals. This makes it difficult
to read your post, and is considered rude - also refered to as
SHOUTING.

Secondly, you should try to describe what you have more fully, by
giving examples of how the data is laid out, the columns you use, the
number of rows, sheet names you use etc., together with a description/
examples of what you want to achieve.

So, have another go, and I'm sure someone will be able to advise you
further.

Hope this helps.

Pete

On Jan 20, 5:30*pm, LARRY wrote:
I'M NEW AT THIS AND NEED SOME HELP. I'VE MADE A WORK BOOK THAT HAS 13 SHEETS
IN IT. I WOULD LIKE TO TAKE THE TOTAL FOR ONE LINE AND ADD IT TO THE LAST
WORKSHEET TO SEE THE GRAND TOTAL FOR EACH SHEET. CAN I DO THIS. FOR EXAMPLE
IF SHEET ONE HAS 10 COLUMNS AS I INPUT THE INFORMATION I WOULD LIKE THE TOTAL
FOR EACH COLUMN TO BE ENTERED INTO THE CELL ON THE LAST WORK SHEET. PLEASE
HELP ME!!!!!!!!!!




All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com