Hi,

I was wondering if someone can help!!

Excel 2010

you have 2 sheets,

In 1st sheet you have a stock list of equipment etc.. with a status tab (New or Deployed, DOA etc...) and a status date (This is the date the action was imputed)

In 2nd sheet you have a list of the device name for example, then you want a list of all the changes to the status tab and date (like a time stamp)

Ideally every time you change the status tab not only will it change the date on sheet 1, but i want it make a copy in sheet 2 over several column,

SHEET1
--------

A B C
Serial Status Date
----------------------
aaa9 New 1/1/12
bbb7 Deployed 12/1/12

SHEET2
--------

A B C D E F G
Serial Status1 Date1 Status2 Date2 Status3 Date3
----------------------
aaa9 New 1/1/12
bbb7 Deployed 12/1/12

Right so if i now make a change to aaa9 from New to Disposal for example i want it to do the following

SHEET1
--------

A B C
Serial Status Date
----------------------
aaa9 Deployed 14/2/12
bbb7 Deployed 12/1/12

SHEET2
--------

A B C D E F G
Serial Status1 Date1 Status2 Date2 Status3 Date3
----------------------
aaa9 New 1/1/12 Deployed 14/2/12
bbb7 Deployed 12/1/12

ETC...ETC....

Is this possible

On the attached file, The Stock tab will get filled out, and you can use the drop down to change the status of a machine, What i want it to the data that is in this cell and the date of it to be copied to the records tab, but if you change the status again it creates a new entry on records tab for that machine (Hence creating a audit trail) is this possible?

Any question please ask

Regards
Dave