SherryO
11-15-2005, 01:47 PM
I have a spreadsheet that has 10 columns and 10,000 rows of formulas. I have it in a dynamic named range (=OFFSET(Source!$A$1,0,0,COUNTA(Source!$A:$A),COUNTA(Source!$1:$1))), which picks up the rows with the formulas in them, but no data as well as the data rows. I am trying to do a paste special values only to get the data that is actuall there to populate a pivot table. My problem is that after I do the paste special values, my pivot table picks up the rows that used to contain formulas as data rows, so I have a bunch of blanks and zeros in my pivot table. Can anyone tell me how to copy the formulas and only get the values for real?
Thanks
Thanks