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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Function with multiple worksheets 6
Formula for cell to get information from other worksheets 1
linking data from one worksheet to another 1
Worksheet several pages, Want name to show up on each page 2
Absolute References and worksheets 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Display information from other worksheet 1
How do I data sort multiple sheets in Excel that are linked with i 1

Back
Top