All,
I have a workbook with a sheet per office, with the same table each time.
i need to send to each office a new workbook with its specific data sheet, plus a pivot table on another sheet, out of that data. Also, I need to create a data entry table, with the same layout as the pivotTable (paste special/formats & values), but I need the total function where corresponding on that input table.
Any suggesstions on how to automate that?
Thanks !!!
Martín
I have a workbook with a sheet per office, with the same table each time.
i need to send to each office a new workbook with its specific data sheet, plus a pivot table on another sheet, out of that data. Also, I need to create a data entry table, with the same layout as the pivotTable (paste special/formats & values), but I need the total function where corresponding on that input table.
Any suggesstions on how to automate that?
Thanks !!!
Martín