That actually works perfectly! Thanks for your help..
I can make this work the only issue I have is… I’m doing this for about 200 people. If I understand your example correctly I’d have to create a reference code in sheet 1 for each person e.g. H2 JohnVA, H3 JohnSL.. etc so it’ll reference the lists B and C with H and bounce back with a total in I. If counted correctly I’d have to manually add approx 5,600 codes for this to work for me!! Tell me I’m missing something simple lol
To be honest a few days work on this putting in those codes would still save more time in the long run. The only issue this creates is say for example john leaves and Jim comes along taking his place additional codes would need to be added for the new employee. I’m trying if I can to remove people from touching this as much as I can as we happen to make mistakes!
Don’t get me wrong what you did here works perfectly and I may very well use it as it really does dynamically pickup everything. Thanks again!![]()
Bookmarks