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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?