ON either Sheet 2 or Sheet 3, you can put this formula in any cell and it
will return whatever value is in cell A1 on sheet 1.

=Sheet1!A1

Vaya con Dios,
Chuck, CABGx3



"deepika" wrote:

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