View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicole M.
 
Posts: n/a
Default Pasting constant formula where referral sheet changes

Just to see if I can make it more clea what I am trying to achieve, this is
an example of a group of cells in the series:

='FP 1'!$I$8 ='FP 1'!$I$9 ='FP 1'!$I$11 ='FP 1'!$I$6
='FP 1'!$I$25 ='FP 1'!$I$26 ='FP 1'!$I$28 ='FP 1'!$I$23
='FP 1'!$I$42 ='FP 1'!$I$43 ='FP 1'!$I$45 ='FP 1'!$I$40
='FP 1'!$I$59 ='FP 1'!$I$60 ='FP 1'!$I$62 ='FP 1'!$I$57
='FP 2'!$I$8 ='FP 2'!$I$9 ='FP 2'!$I$11 ='FP 2'!$I$6
='FP 2'!$I$25 ='FP 2'!$I$26 ='FP 2'!$I$28 ='FP 2'!$I$23
='FP 2'!$I$42 ='FP 2'!$I$43 ='FP 2'!$I$45 ='FP 2'!$I$40
='FP 2'!$I$59 ='FP 2'!$I$60 ='FP 2'!$I$62 ='FP 2'!$I$57
='FP 3'!$I$8 ='FP 3'!$I$9 ='FP 3'!$I$11 ='FP 3'!$I$6
='FP 3'!$I$25 ='FP 3'!$I$26 ='FP 3'!$I$28 ='FP 3'!$I$23
='FP 3'!$I$42 ='FP 3'!$I$43 ='FP 3'!$I$45 ='FP 3'!$I$40
='FP 3'!$I$59 ='FP 3'!$I$60 ='FP 3'!$I$62 ='FP 3'!$I$57