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
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