userform with looping code

1/. If you change a sheet name you wiil have to change the code throughout, Find and Replace in VBa is the easiest way. (Any forrmulae will take care of themselves)

2/. I think I have found the bug when changing the Names List and it should be okay now
To change the names in the lookup list change or paste in whatever you need, make sure the list is continuous, don't leave any blank cells in the list. Sort the list alphabetically if you wish.

If the list has less than 90 names you will not be able to fill the entire table, if there are more than 90 then you will have some left in the drop-down list when the table is filled.

I have added conditional formatting to make the text turn red if a name is deleted from the list but is still in the Log ( This will only work for 2007 on as it stands)

3/. I assumed you would not want to delete the entire log on a regular basis, but if you do just clear all the data except the headers. Avoid deleting rows I haven't addressed that scenario and it could well break the Named Ranges


This will still need debugging, so please check things step at a time so that errors can be easier to trace.

I will check it out in 2003 when I get the chance, but I don't have access to a machine at the moment. I don't think you need combine the sheets, the validation lists are VBa generated, but I will test in 2003 later.

Have fun....