| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| How do you make information from one worksheet feed to another? | Excel Worksheet Functions | |||
| How do I bring totals from one worksheet onto the second worksheet | Excel Worksheet Functions | |||
| Pull information from one worksheet to another | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Linear Mode
