how can i fill data in blank cells after copying a pivot report?
 

I need to fill data in blank cells after copying a pivot report as values.
At present this is being done by copying individual cell values and pasting
it on the blank cells below.

how can i fill data in blank cells after copying a pivot report?
 

You can use Edit: Go To: Fill Blanks to paste a formula. Here's a step by
step.

http://www.kan.org/tips/excel_fill_blanks.php

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Antz" wrote:

I need to fill data in blank cells after copying a pivot report as values.
At present this is being done by copying individual cell values and pasting
it on the blank cells below.