Thread: using 'fill right' to copy formulas in a pivot table, keeping some data elements constant
View Single Post
 
Old 01-16-2017, 07:00 PM
jfeinstein jfeinstein is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Dec 2016
Posts: 5
jfeinstein is on a distinguished road
Default
Does anyone have a solution that I am missing? Please see last post. The row that is not calculating correctly is row 14 in the sheet Hours by Title Q1. In column C, for example, it should no longer use the data in cells B6-B12 (multiplied by the values in A6-A12), but should instead be using values in C6-C12, multiplied by the values in A6-A12.
Reply With Quote