SAPDump is a data Sheet. Thereafter a Pivot Table is Prepared taking dump from SAP namely Pivot Table of SAP Dump. ABP is a Budget from which data are taken to prepare Reports. Data Are also Taken from Pivot Table. In MIS Sheet I have to Fill the relevants. I want to automate filling of data from PIVOT TABLE SHEET AND ABP Sheets.Hi Pankaj,
Can you elaborate your requirement more in details like which sheets will be data what is pivot table for, in which sheet you want automation how is data added and any other details that required to do the task.
Regards,
See the attached file. I had added some formulas in ABP sheet & MIS sheet. Just check the data.
Regards,
Hi Pankaj,
See I think you want a revised formula Column B & Column F on Sheet MIS. If this correct then column B formula are working OK.
and column F formula should be updated as below in F4 and copy down:
=SUMIFS(Table1[Amount],Table1[EXP code],MIS!$D4,Table1[y/m],"<="&"2014/02",Table1[y/m],">=2014/01")
Regards,