Help in moving row of information in excel format

[pajames]

I am trying to set up a production flow excel sheet. I would part of a row
of information to move to the next work sheet when one specific column in the
row is filled in. To move client information from one department to the next
when it is initialed out of the first department?

Is this too much to ask? Seems like it should be simple enough but I have
limited knowledge of Excel.

Any help greatly appreciated.

 

[VENKAT]

some expert may give a better solution. meanwhile
name the range e.g. "alpha"
go to sheet2 and highlight the same no. of cells in a row and in the first
cell type
=alpha
and hit
CTRL+SHIFT+ENTER
===========================