dobbsy82
07-04-2011, 05:47 AM
Hi, if someone can help me with a VBA code to do the following i would be very grateful.
The 'Diary' worksheet contains rows of data for customers with a loan out. columns J, K and L show different dates for different actions. Column M shows the status of the loan, either having a 1, 2 or 3 inserted.
When a 3 is typed in to column M, columns A, B, F, G and H should be taken out of that row and enter into the worksheet 'closed', in the corresponding columns, the headings correspond to that in the 'Diary' worksheet. The rest of the data in columns P, Q and R should delete out of the row.
The reason i dont want columns C, D, E is because they are formulated and that formula needs to stay there for the next customers.
I hope this is clear enough!
Thanks in advance
The 'Diary' worksheet contains rows of data for customers with a loan out. columns J, K and L show different dates for different actions. Column M shows the status of the loan, either having a 1, 2 or 3 inserted.
When a 3 is typed in to column M, columns A, B, F, G and H should be taken out of that row and enter into the worksheet 'closed', in the corresponding columns, the headings correspond to that in the 'Diary' worksheet. The rest of the data in columns P, Q and R should delete out of the row.
The reason i dont want columns C, D, E is because they are formulated and that formula needs to stay there for the next customers.
I hope this is clear enough!
Thanks in advance