excel spreadsheet

[deepika]

there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets.
the first sheet is used as input and based on certain fields , columns in
the first sheet i need to populate entries in the second and 3 rd sheet.
teh main purpose is taht based on the first sheet the 2 and 3 sheet should
be automatically filled. wat kind of formula / macro should i be using ..
im new to this and jsut know to create macro. CAn anybody help

 

[Gary''s Student]

It is easy to pull values from one worksheet into another. Let's say that in
Sheet1 cell A100 we have data we want to use in Sheet3 cell Z100.

In Sheet3 cell Z100 enter:

=Sheet1!A100

Whenever the value in Sheet1 is changed, the value in Sheet3 will follow
suite automatically.