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.
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.