Help with Excel

  Tulips 21:44 19 Jul 2008

Dear all, how do I get from =SUM('W1'!E$36:F$36) to =SUM('W38'!E$36:F$36) the way I do it at the moment is click on the cell with =SUM('W1'!E$36:F$36)in it and drag it down 38 cells and then manually change the W1 into W2 and so on but I have over 3,000 cells to change so I'm looking for an easier way, hope this is clear enough.

  VoG II 21:54 19 Jul 2008



  Tulips 22:10 19 Jul 2008

Sorry, am I missing something here, do I just copy the above and paste it in the appropriate cell and drag it down and job done or do I put some other info in there?

  VoG II 22:15 19 Jul 2008

Put the formula in row 1 and fill down. However I'm not sure that I fully understood your requirements but try it anyway.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?