Paste Special

  • Thread starter Thread starter acceber
  • Start date Start date
A

acceber

I am trying to copy and paste formulas from 4 workbooks into one. The
formula looks like this ='[03 Dec.xls]Summary'!$K$10+'[03
Sept.xls]Summary'!$K$10+'[04 April.xls]Summary'!$K$10+K10 and what I
want to do it copy this formula with each line so the next one will
look like this ='[03 Dec.xls]Summary'!$K$11+'[03
Sept.xls]Summary'!$K$11+'[04 April.xls]Summary'!$K$11+K11 and so on. I
know if I am in the same worksheet a simple copy and paste will work.
Is there anything I can different so I don't have to go through each
one?
 
Hi

If I understand you right; remove the dollar signs from your formulas.

HTH. Best wishes Harald
 
Back
Top