So, now my first problem has been kindly fixed, I have another query. This will just be a nice bonus if I can get it to work.
I have a workbook with an overview sheet of jobs. When I select a city in column 6, for example London, the entire row is copied to the London spreadsheet.
When I come to complete the job, I select Completed in column 9 on the Overview sheet and it copies it the entire row to the Completed sheet and deletes it from the Overview sheet.
What I'm now after is to find a way for that action to delete the duplicate in the London sheet? As it is, I have to go into the City sheet and delete the job manually.
I was advised that there needs to be a unique reference for each job (thanks Fluff) and this might be an issue. Most jobs have a unique reference number but there are some anomolies in which rather than a ref number, it could be a name or address, and these could be repeated in future so it wouldn't be unique. eg, the reference column (Column D) will have 1234, 2833, 1834, and so on, then there might be one where the only reference would be Bloople. And next month, there might be another job relating to Bloople, and you'd never know what number you're up to so can't just add a number on the end.
I have a workbook with an overview sheet of jobs. When I select a city in column 6, for example London, the entire row is copied to the London spreadsheet.
When I come to complete the job, I select Completed in column 9 on the Overview sheet and it copies it the entire row to the Completed sheet and deletes it from the Overview sheet.
What I'm now after is to find a way for that action to delete the duplicate in the London sheet? As it is, I have to go into the City sheet and delete the job manually.
I was advised that there needs to be a unique reference for each job (thanks Fluff) and this might be an issue. Most jobs have a unique reference number but there are some anomolies in which rather than a ref number, it could be a name or address, and these could be repeated in future so it wouldn't be unique. eg, the reference column (Column D) will have 1234, 2833, 1834, and so on, then there might be one where the only reference would be Bloople. And next month, there might be another job relating to Bloople, and you'd never know what number you're up to so can't just add a number on the end.