Excel problem

  neil_raj 19:00 12 Nov 2005

Hi all.

I have heard of a way were you can type data in sheet 1 and it automatically replicates in sheet 2. I have forgotten the formula for this. I'm not talking about copying and pasting from s1 to s2.

Can anyone help?

Thanks........... Neil.

  VoG II 19:17 12 Nov 2005

You need a formula like

='my first sheet'!A1

in A1 of the second sheet. Then just copy the formula across and down as far as you need.

  Simsy 19:37 12 Nov 2005

perhaps what you want...

Select the Sheet1 using the tab at the bottom left... hold CTL and select Sheet2...

They are both now selected and any typing you do in any cell will be in that cell on both sheets.

Does that help?



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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017