I am struggling a bit my Test.xls is a dashboard that is based on a pivot chart at the moment i create the final.xlsx with easymorph its a compilation of 12 different excels I get every month. Than i manually copy and paste it into my test.xlsx and update the pivot chart. Is there a way to automate this? I tried around and i cannot seem to get it done.
thank you for the answer unfortunately its not quiet what I meant. The provided Example does not Apply for me. I get new Values for every month and these are added into the pivot Database. I do not want to replace the previous Data. Furthermore I then want easymorph to run my macro which is possible to automatically email my xls. For this im looking for a way to automate the pivot through easymorph
The append function did not work for me that’s why I opened a forum post … Will that automatically update the excel pivot from easy morph ? Sending an email from easy morph is possible I know but it’s pointless if the pivot is not updated automatically without opening the excel first