Manipulating Data Problem
 

Hi,

I have two problems I am stumped about.

I have a row of data in the range A2:M2

I want to copy this range and paste the values at the bottom of the list or
in the row immediately below if it is empty.
After pasting the values, the contents of range A2:M2 are deleted.

The other problem

I have a column of data. I want to find the value of the cell at the bottom
of a list the value of which could be anywhere in the range C10:C118

Assistance greatfully accepted.

Jeff