Firstly, I am a novice and therefore any instructions need to be idiot proof.

I have several spreadsheets that I receive daily.

I seem to do the same routines on a daily basis and was therefore wondering
if it can be automated.

This is what I do on a daily basis: -

Open them;

Position on the second column and depress END and down arrow (to get me to
the last row);

Retype the value that is currently in that cell (i.e. if it say 578, I just
retype it) and change the format of the cell from a date format (dd/mm/yy) to
a general number. The reason I retype the value is that there is a formula in
the cell;

I then manually delete all the rows except the first and the last rows.

I have tried to record a macro but it inserts a cell references and
unfortunately this doesnt work as the range to be deleted changes on a daily
basis.

Can the above task(s) be automated so that I just run a macro?


Any help offered would me appreciated.

--
Thanks

Ann