sindhuja
03-17-2012, 10:19 AM
Hi,
i have a sheet named "details" from which i create a pivot in the "Pivot" sheet.
Now what i want to do is check value in column A of pivot values in the "Master sheet". if the value is found (eg - ABC) then we need to amend the values accordingly. If the date is present we need to add the new value to the existing value, else only the new value.
If the value not found (eg - ZYX) in the "Master" sheet then enter the store in the last row and amend the values as per the date.
The date should be the fortnight dates. Based on the today date it should add accordingly in the master date. for example if todays date is 17/03/12 then the last date value should be 15/03/12.
I have attached the sample sheet for the reference.
Pls assist..:help
i have a sheet named "details" from which i create a pivot in the "Pivot" sheet.
Now what i want to do is check value in column A of pivot values in the "Master sheet". if the value is found (eg - ABC) then we need to amend the values accordingly. If the date is present we need to add the new value to the existing value, else only the new value.
If the value not found (eg - ZYX) in the "Master" sheet then enter the store in the last row and amend the values as per the date.
The date should be the fortnight dates. Based on the today date it should add accordingly in the master date. for example if todays date is 17/03/12 then the last date value should be 15/03/12.
I have attached the sample sheet for the reference.
Pls assist..:help