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.

 

[uv]

if the £100 is in, say cell D12 on sheet1, then on sheet two you need to write "=Sheet1!D12" - without the quotes - for it to propagate from the contents of the first sheet.

Not too sure about the date, though

 

[Ish]

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

 

[Namsnik]

To do the date thing you would need to use VBA (a macro). You can create a macro that runs automatically when a cell or range of cells changes.