Hello,

I am a newbie at excel, so I would probably need pretty basic instructions. What I'm looking at doing is moving a complete row of information once each cell on that row has a value and copy to another row of the same sheet. To be exact, the last row with information (ex. row #20), once filled, I want it to automatically be copied on row #4 (which would have the latest updated information) If the next row, row #21 is filled, then the information on row #4 needs to change.

thanks for your help

Pier