dtziournas
New Member
- Joined
- Dec 14, 2009
- Messages
- 5
I have 2 tables one which i am entering data for current month and 2nd table i have consolidated on table all the months of year.
At the end of the month I copy paste the values of each month and I have created a formula that when I am changing the month value the data will rollover to next month.
formula is : =IF($S$5=Guide!$AB$92,Inventory!CN6,0)
S5 is month value
GuideAB92 is the current month value
InventoryCN6 is the value tht I want to be pasted.
Every month I am deleting the data from 1st table(inventory) but before that have to copy paste values under the month we finish in order to not loose the date when I am changing the value to move to next month
Is any way to populate the 2nd table dynamically without doing the copy/paste at the end of the month ?
At the end of the month I copy paste the values of each month and I have created a formula that when I am changing the month value the data will rollover to next month.
formula is : =IF($S$5=Guide!$AB$92,Inventory!CN6,0)
S5 is month value
GuideAB92 is the current month value
InventoryCN6 is the value tht I want to be pasted.
Every month I am deleting the data from 1st table(inventory) but before that have to copy paste values under the month we finish in order to not loose the date when I am changing the value to move to next month
Is any way to populate the 2nd table dynamically without doing the copy/paste at the end of the month ?