A Formula to Create A Summary Sheet In XL03

artiststevens

New Member
Joined
Aug 9, 2010
Messages
27
Hello,
I update the inventory for my business daily but
I have different inventory sheets, in the same workbook,
with different items listed on them. I wanted to
create a summary sheet that would give me
the inventory for the current day and updated to
the following day when new information is added.

Example:
Inventory Page
8/9/10: 5 widgets/10 thingys/7 whatsits

Summary Page
(Would be the same)
8/9/10: 5 widgets/10 thingys/7 whatsits

But When I entered the Inventory for 8/10/10 it
would change to that but only when I entered something
new in the empty cells below 8/9/10. I want the summary sheet
to constantly roll over to the new days information,
while the inventory pages serve as archives. I hope I explained
my problem well enough and I hope someone can help me.

- Thanking You In Advance
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,109,087
Messages
5,526,772
Members
409,720
Latest member
Antwain

This Week's Hot Topics

Top