Excel - using data from other worksheet

  SWEENEY TOD 17:41 10 Feb 2008
Locked

Please can anyone remind me how to type in the formula for accessing data from worksheet 1 and using the data on worksheet 2 for instance all in the same work book. I used to do it but forgot how . I am using XP.

  VoG II 17:44 10 Feb 2008

Something like

='First Sheet'!A1 + 'Second Sheet'!C3

The ' are only necessary if there are spaces in the sheet name.

  recap 17:46 10 Feb 2008

In the cell you want the data to be in insert theworksheet 1 = sign in the cell you want the dats. Then go to worksheet 2 click in the cell with the data and press enter.

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

Elsewhere on IDG sites

What is ransomware and how do I protect my PC from Petya?

Illustrator Mariana Rodrigues' beautiful flora and fauna for Bombay Sapphire gin

How to remove Mac ransomware

Comment mettre à jour Kodi ?