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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,844
Messages
5,507,644
Members
408,641
Latest member
billigee

This Week's Hot Topics

Top