Automatic Copying of 2 columns to other sheets

[Supergran]

Hi, I have a workbook with few sheets. In sheet one the first 2 columns are going to be the same in sheet 2 and 3. Is there a way to make these entries automatically fill in sheet 2 and 3 without copying and pasting. Thanks for your help

 

[Nebu]

Hi:

Do it using cell references.

Thanks

 

[Supergran]

Hi, Sorry I'm a novice with Excel and I don't know what this means. I probably should have said in original request I want to auto populate first 2 columns from sheet 1 to sheet 2 and 3. column 1 has a number, column 2 has a name and I want these to appear on each sheet but the rest of the information is different. Thanks

 

[Nebu]

Hi:

If your want your sheet 1 cell A1 value in sheet 2 or sheet 3 you have to call it using cell reference like =Sheet1!A1.

Here is a link which explains the concept
http://www.tech-recipes.com/rx/1604/excel_how_to_reference_cells_in_other_worksheets/

Thanks