I'm not sure if I on the right board, but this is my question. Is it possible to create macro or some function to automatically update ordinary Table from Pivot Table. You can see in example that I have Pivot table (in "Report" sheet is data for it), and below Pivot Table I have the same one but normally table.
Therefore, next month when I include the data for November, Pivot table can be refreshed on the click, but is there any way to Refresh the table below Pivot automatically?
My Chart is depended on Second Table. Any options to include new data from second Table in Chart automatically?
Please, just don't say: COPY/PASTE :D
Thank you!
Bookmarks