Transfer of data from one worksheet to another when drop down selected

**DJ_Rutts** · 10-18-2010, 05:52 AM

Hi guys,

I have been receiving great help in here with the tables I have been building and just need a last bit of help please.

I already have VBA's for work sheet's 1 and 2 which sorts the data but what I am hoping to do now is add an additional drop down under the status tab on 'Outstanding' work sheet. This extra drop down will be 'Implemented' and when it is selected I would like the details from column 'A' to be transferred onto work sheet 'Completed' into column 'A'.

It can just go to the bottom of this worksheet and the user can then complete the rest of the row. The entry on the 'Oustanding' work sheet should be automatically deleted.

Can anybody let me know if this would be possible?

Thanks in advance!

Dan

**Leith Ross** · 10-18-2010, 01:07 PM

Hello DJ,

I helped you with this project about 6 weeks ago. It is possible to adjust the code to move and clear the data. I am assuming this will be triggered by "Status Changed", yes?

**DJ_Rutts** · 10-19-2010, 08:42 AM

Hi Leith,

yes you did - and were very helpful thank you. Yes - the change would be when the status has changed. I have not added the new status to the list yet but was going to add an 'implemented' status, so once that is selected the row is cleared and it goes to the bottom of the 'completed' table on the next worksheet until the rest of the details are filled in.

Is it possible to make the job name bold on the new worksheet until the rest of the row is completed?

Thanks

Dan

**DJ_Rutts** · 10-20-2010, 05:21 AM

Hi,

I am sorry to mess you about but I have had to make some further changes to the spreadsheet. I have added extra columns on both the outstanding and completed worksheet so have attached the new workbook for you. I have obviously messed up the current VBA's by doing this and have been trying to amend them but without success! I have therefore put them back as they were. Could you help by advising me which parts I need to tweak in order to get back up and running again?

Also I have realised that when I put a date into the 'status changed' column on the 'outstanding' worksheet, it switches it to the US date version, even though I have set the cells to the UK version.

Again - many thanks in advance

Dan