Copy the selected cell row and paste in another sheet

[Mooohan]

Hi,

Please help me on this one. When i select a cell(ex: A2 or c4 or B5) in a row in sheet 1, then that row should be copied to sheet 2. When i select another cell in someother row in sheet 1 then the earlier row should be removed in sheet 2 and currently selected cell row in sheet 1 should be copied to sheet 2.

Thanks in advance

[PCI]

Where is sheet 2 ??
Is sheet 2 the name of the sheet ?

[Mooohan]

Hi PCI,

Yes sheet 2 is name of the next sheet. Please help

[PCI]

And what about the location where to put the row in sheet 2 ???

[Mooohan]

Hello,

I need to put the copied row in row 2 of sheet 2. Inspite of watever row i select from sheet 1, it should be pasted in row 2 of sheet 2.

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.