How do I get information on worksheet 1 to show in other wkshts?

J

JDsSquirrel

I'm working on a spreadsheet for my sister...I need information I type in on
page 1 to also be on subsequent pages (with as little effort as
possible)...and information from other pages to show on page 1...how do I do
this. It's for tracking the progress of her students and there are quite a
few of them...and lots of information to sort. I've used Macros to do the
initial input, and sorting of names...
 
J

JLatham

You can set up cell formulas to reference cells on any other sheet in the
workbook. To type one in, lets say you're on Sheet1 and want to have info
from Sheet2, cell A1 visible at B19 on Sheet1. On Sheet1, in cell B19 you
could put this formula:
=Sheet1!A1

Sometimes it's easier to let Excel do the work. You could click in cell B19
 
Top