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

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