macro to copy
 

My data is from A35 to GB160. Formulas in this worksheet are protected. I
would like to do a macro to copy a row to the last row of this range that is
blank (row 35: row 160).
Example:
If I shaded 1 entire row (example row 40), I would like to copy the whole
row and paste special value and formula to the last row (from 35:160) that
have no data yet (example in this case: blank row is row 68) . Remember that
the workbook is protected, so that in a row there is a chunk of values,
following by formulas, then values, than formulas...and so on.
Thank you