copy line to another line when data is recorded in a cell

[alestra]

I have a PO Spread sheet that has 3 different types of POs. I would like to automate it when I put a value in J1 then copy the whole line and past it in A61. Same thing when I post a value in J2, copy and past in A62

[NBVC]

Maybe something like this, in A61:

=IF($J1="","",J1) copied across and down as far as you desire.

This will look to see if there is something in J1, if so, it will "copy" it to A61. If you copy the formula to B61, C61, D61, etc.. it will copy what is in K1, L1, M1, etc (only when J1 is not blank).

If you copy down, then in A62 it will look to see if J2 is blank and copy/or not... and copying this across wil get K2, L2, M2, etc..

etc...