B
Bud
While working in a pivot table, I accidentally created a new worksheet in my
file with isolated data from the report e.g. pivot table shows all days of
the month with totals for each deposit account... my 'accident' created a
sheet with all the data for a single date. It turns out, this would be a
useful tool for my manager, but we cannot reproduce my accident. My mouse
was on the blitz and after a few solo selections the new worksheet appeared.
Does anyone know how to do this (intentionally)?
Please help.
file with isolated data from the report e.g. pivot table shows all days of
the month with totals for each deposit account... my 'accident' created a
sheet with all the data for a single date. It turns out, this would be a
useful tool for my manager, but we cannot reproduce my accident. My mouse
was on the blitz and after a few solo selections the new worksheet appeared.
Does anyone know how to do this (intentionally)?
Please help.