To Keep Only A Tatal Amount, But Not Keeping The Whole Sheet

  • Thread starter Thread starter freeecoom
  • Start date Start date
F

freeecoom

Hello everyone,
I need to create a workbook, which has 2 sheets A and B. Sheet A i
for insert data and sheet B is for the total amount of sheet A.

Every day, I enter a lot of numbers in sheet A and sheet B will show m
the total amount of sheet A. I don't need to keep every detail in shee
A, but I have to keep the total amount of that day.

Because I don't need to keep every detail in sheet A, the next day,
open sheet A again and enter new numbers for a new day. The problem i
when I enter new numbers, I get only the total amount of the current da
in sheet B. I lost the total amount of the last day.

Please dirent me how to keep only the total amount without keeping th
related sheet.

(I have tried to enter data for every day in separated sheets, but th
problem was the workbook's size is huge ---> It took a long time t
open!)

Thank you very much and I look forwards to hearing from you.
Regards,
Pete
 
How about making a sheet3. Then copy the totals from sheet2 and paste special
values into sheet3.
 
Back
Top