Hi Expert,
I have an excel macro that getting the file from raw data and copy to target template which is already working.
In my raw data i have a column for Month, the format is "DEC-13" what is the current month is "JAN-14". In my Target template i have a pivot table the filtering based on Month based on report filter. Its possible to validate if new records added then filtering of records will perform else the records is still the same.
my requirements is to automate this functionality based on month. Your help is very much appreciated. Thank you.
Attached is my sample data with macro code.
sample:
Field------Value
--------------------
Month: Dec-13 --Select multiple items
Bookmarks