Bring information from one worksheet to another
 

I am fairly new to working with Excel. I have 3 worksheets on one file. Each
of these worksheets look identical with exception of some colors. I want
specific information that I enter on worksheet 1 to transfer to the other 2
worksheets. Anyone know how to do that?

Bring information from one worksheet to another
 

Assume you enter data in cell A1 on sheet 1. Entering the following formula
anywhere in sheet 2 will link that cell to A1 on sheet 1: =Sheet1!A1
--
Brevity is the soul of wit.


"Jody" wrote:

I am fairly new to working with Excel. I have 3 worksheets on one file. Each
of these worksheets look identical with exception of some colors. I want
specific information that I enter on worksheet 1 to transfer to the other 2
worksheets. Anyone know how to do that?

Bring information from one worksheet to another
 

Thanks!

"Dave F" wrote:

Assume you enter data in cell A1 on sheet 1. Entering the following formula
anywhere in sheet 2 will link that cell to A1 on sheet 1: =Sheet1!A1
--
Brevity is the soul of wit.


"Jody" wrote:

I am fairly new to working with Excel. I have 3 worksheets on one file. Each
of these worksheets look identical with exception of some colors. I want
specific information that I enter on worksheet 1 to transfer to the other 2
worksheets. Anyone know how to do that?