One for the Excel people

[Ish]

Hi

I have a spreadsheet which is on one sheet.

What I want it to do is that when I enter a figure in certain cells the figure gets copies over to sheet 2 eg:-

In sheet 1 in certain cells I enter the figures £100, £200, £300. What I want is for these figures to be displayed on sheet 2 as a list eg:-
£100
£200
£300

An even better thing would be if these figures that were being copied into sheet 2 had the date next to them of when they were entered into sheet 1.

Any help would be much appreciated.

Thanks.

 

[Ish]

Thanks...i'll give it a try.