if i copy and paste values for my pivot table is there an easy way to fill in
the blanks - my list is 10000 rows and it would take hours to fill in manually

"olasa" wrote:


You could use this formula in column D:
=IF(ISBLANK(A5),A4,A5)

You can't do what you want to do, in the Pivottable.

Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378947