I need a macro that will copy data from worksheet pivot...based on the data in column a I.e copy all the data above the txt Grand Total and paste into new workbook and save workbook to file path \\gpobal.yftuu\hfghj\ da
te & .xlsx file...
starting range is always A6:hx where is depend on column a and one less grand total txt..
If not you can just do a Worksheet Copy and then break the links or copy and paste all with values.
If that is what you want, let us know and I will sort the macro for you.