Excel help required!

  neil_raj 18:36 14 Dec 2006
Locked

Hi all.

Anybody know of a website that can helpfully expalin step-by-step how to switch from one worksheet to another in the same workbook and include all the changes that are made from the original worksheet.

I need to make two sheets work side-by-side, the formula, enteries etc that I put in the first shhet should automatically by entered in the 2nd sheet.

THANKS.... Neil.

  VoG II 18:40 14 Dec 2006

In A1 of the second sheet enter

='Sheet1'!A1

and copy down and across as far as needed.

Or you could use a Worksheet_Change macro.

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

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique