Exel worksheet formula

  SWEENEY TOD 09:55 04 Mar 2006
Locked

Hi Folks

I am ok using excl spread sheets etc., but would like to know if there was a way of for instance .....
an active cell on worksheet 1. affecting a cell on worksheet 2.This is so i can generate furthur calculations on a different sheet but is related to information on other sheet. Do i make any sence
Tried looking in ECDL training books but could't find anything.

  VoG II 09:59 04 Mar 2006

To reger to a cell on another sheet use a formula like

='Sheet1'!A1

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?