Dear Sir,
Recently I have faced a problem with regard to Pivot Table in arranging data .I could not arrange or sort the the column K "Job Set Time" of sheet 1 which is composed of date and time. This I achieved in Sheet2 by copying and pasting the Pivot data.And then using filter.There comes the option "Sort oldest to Newest" in dropdown filter.But the same does option "Sort oldest to Newest" does not appear in the sheet 1. As I do have a lot of Pivot tables and in this way copying and pasting takes a lot of time.
Is there any method of doing so.If so then kindly let me know.
I have attached file.
With Best Rgds
suresh
Recently I have faced a problem with regard to Pivot Table in arranging data .I could not arrange or sort the the column K "Job Set Time" of sheet 1 which is composed of date and time. This I achieved in Sheet2 by copying and pasting the Pivot data.And then using filter.There comes the option "Sort oldest to Newest" in dropdown filter.But the same does option "Sort oldest to Newest" does not appear in the sheet 1. As I do have a lot of Pivot tables and in this way copying and pasting takes a lot of time.
Is there any method of doing so.If so then kindly let me know.
I have attached file.
With Best Rgds
suresh