Help Regarding Excel 2003

[sainit]

Hello Everyone!!

Can anybody help me about MS Excel 2003?

I want to display value from a row in Sheet1 to in Sheet3 in formatted manner (In different columns) and whenever I change the row number the value displayed in sheet3 in reference to that row number should be displayed.

Pls help me it’s very urgent.

Thanx

 

[Pragadheesh]

cant get ur problem sainit.. plz be a bit more clear and describe ur problem in detail..

 

[piyush gupta]

use this

=Sheet1!A1

in column of sheet3 for value of cell A1 of sheet1

Where Sheet1 is name of your first sheet

 

[sainit]

Friends,

I have data in Sheet1 from A1:C7. Now i want to put data from A2:C2 in Sheet3 in such a manner that whenever i change the value of A2 like A2 to A3 or A3 to A4 the remaining coloumns B2 & C2 also should be changed according to that.

I hope u r getting me.

Thanx