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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,108,839
Messages
5,525,160
Members
409,628
Latest member
inatecktechnology

This Week's Hot Topics

Top