Hi Experts,
Any help is really appreciated. It is a straight forward situation.
I have file I am manipulating to create pivot tables, my manipulated file needs to update when ever the parent file updates and also my pivot tables should update.
I dont know how to write VBA code. Is there an example with which I can change a few simple things and get it done.
The Parent file is located on a common drive and I have made a local copy of this and manipulated it to get an excel spread sheet.
Now I use this sheet to create pivot tables and generate a report for the user.
So how do i link these files.
Please suggest. thanks in advance
Bookmarks