Hi to all.

I have an Excel file and i want when the value of the column b change copy all the lines before change in a new Workbook.
In this Excel i also have a pivot which i want to copy also.

The problem is this.
After the copy of the pivot i want to see the data from the new workbook and not from the old.

I hope you understand what I want to do because my English is not as good as possible.

Thanks and regards.