B
BigDave
I am experiencing a problem when copying data from one data sheet into
"master" data sheet that utilizes a Pivot Table.
When I copy a group of cells that include some that are blank (via
validation) and then paste them into the master data sheet the Pivo
Table is not seeing them as blank. Rather, it is seeing them havin
the same value as the next completed cell above the blanks. To correc
it, we go into the "master" sheet and clear contents/delete the cell
we know are supposed to be blank.
Is something happening during the copy process that would be puttin
some data into a cell that we cannot see
"master" data sheet that utilizes a Pivot Table.
When I copy a group of cells that include some that are blank (via
validation) and then paste them into the master data sheet the Pivo
Table is not seeing them as blank. Rather, it is seeing them havin
the same value as the next completed cell above the blanks. To correc
it, we go into the "master" sheet and clear contents/delete the cell
we know are supposed to be blank.
Is something happening during the copy process that would be puttin
some data into a cell that we cannot see