Cell Values

[Karan]

Hi,

I am using Microsoft Excel 2000 and Windows 98.

I have a excel file which has two sheets in it. One is Dialy Summary &
another sheet is called Monthly Summary.

We keep receiving different products daily - which goes into Daily Summary
sheet.
I have a consolidated total of each day received product in monthly summary.

For Example: imagine we have 5 products, we receive products on 1st Day of
the month.
Product1 > We receive 10 Nos.
Product2> We receive 05 Nos.
Product3> We didn't receive anything.
Product4> We didn't receive anything.
Product5> We receive 15 Nos.

we receive products on 2nd Day of the month.
Product1 > We receive 15 Nos.
Product2> We receive 10 Nos.
Product3> We receive 05 Nos.
Product4> We didn't receive anything.
Product5> We receive 05 Nos.

In the monthly Summary sheet should show as below:
Which is total:
Product1 > 25 Nos.
Product2> 15 Nos.
Product3> 05 Nos.
Product4> 00 Nos.
Product5> 20 Nos.

NOW, i want the following to happen. I want to have only these two Sheets,
doesn't want to add more sheets. When we receive stock on the 1st Day i
enter the Received Number of Products in the Cell.
A1 > 10
A2 > 05
A3 > 00
A4 > 00
A5 > 15
(The Same values will be shown in the Monthly Summary sheet) When we receive
the 2nd day Stock I enter the values on top of the 1st Day Values. In the
Monthly Summary sheet, it should show the total Number of products of 1st
Day & 2nd Day &..........

for example i enter the values in the same cells for 2nd Day
A1 > 15
A2 > 10
A3 > 05
A4 > 00
A5 > 05

Without adding in to the cell. When i open the sheet it should only show
todays received stock. which is the 2nd Day and the 1st Day stock should be
added to the monthly summary.

any idea how to go about it.

any suggestions will be greatly appreciated.

Thanks & Warm Regards,

Karan.

 

[Otto Moehrbach]

Karan
I think I can help you with this but I don't follow what you want to do.
Remember that no one in this NG knows your business. Try to explain
what you want in a step by step procedure. For instance:
Start with both sheets blank except for headers.
You open the workbook.
You enter something. Where?
What do you want to happen when you make this first entry?
Is this all that you will enter today?
If not, what do want to see or what do you want to happen when you make the
second entry?
What do you want to happen with the first entry when you make the second
entry?
What do you want to see when you open the workbook tomorrow?
HTH Otto

 

[Dave Hawley]

Hi Karan

You should keep all related data on the one sheet. Then, from this
sheet, base a Pivot Table.

http://www.ozgrid.com/Excel/excel-pivot-tables.htm

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***