• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details

Help Regarding Excel 2003

Status
Not open for further replies.

sainit

Journeyman
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
 

piyush gupta

Cyborg Agent
use this

=Sheet1!A1

in column of sheet3 for value of cell A1 of sheet1

Where Sheet1 is name of your first sheet
 
OP
S

sainit

Journeyman
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
 
Status
Not open for further replies.
Top Bottom