| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Entering same data, two worksheets
I know this is a simple problem for you pros. I am working with two
worksheets in the same workbook. I want to type lets say a date (or file number, address, etc) into a cell in worksheet "A" and have the same data entered in the same cell on worksheet "B" without having to copy and paste special each cell. Can you have an entire column equal another exactly on another worksheet? Thanks much - MD |
|
#2
|
|||
|
|||
|
Hi Mark
assuming the sheets are named Sheet1 and Sheet2 respectively In Sheet2 cell A1 enter =Sheet1!A1 Copy down column A of Sheet 2 as far as you wish. Anything typed in column A of Sheet1 will be replicated on Shet2 -- Regards Roger Govier "Mark from Michigan" wrote in message ... I know this is a simple problem for you pros. I am working with two worksheets in the same workbook. I want to type lets say a date (or file number, address, etc) into a cell in worksheet "A" and have the same data entered in the same cell on worksheet "B" without having to copy and paste special each cell. Can you have an entire column equal another exactly on another worksheet? Thanks much - MD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| working with data between worksheets | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
