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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Data entry for two worksheets 1
Excel 2003 - Relocating an entire row of from one worksheet to ano 2
Excel VBA 1
Get location of match in another worksheet 2
Formulas that recognise data from two worksheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top