Can I get cells on another sheet to fill in automatically?

[acncguy]

Hi -

I was wondering if you can get cells from one sheet to automatically fill in on another sheet, instead of having to retype the info? If so, how is this done? I haven't worked with Excel in awhile but when I did, I thought I did this but I don't remember how.

Thanks for any help.

 

[JoeMo]

Say you want cells in Sheet2 to fill automatically when their companion cells on Sheet1 are changed.

Then for cell A1 on sheet2 enter:

=Sheet1!A1

Or if you name your sheets like "My Sheet" where there are spaces in the name:

='MySheet'!A1

 

[acncguy]

Perfect! Thanks.