Entering same data, two worksheets

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

Guest

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
 
Back
Top