Here is a link to my original post:- http://www.excelforum.com/showthread.php?t=1169539
Although the above post solved my initial problem I soon realized that I had to change my workbook layout in order to make it manageable and easier to use.
Where as the previous version had 1 sheet/tab for all staff I had to change it so I now have a number of tabs across the bottom which relates to the first letter of a persons surname
Example:
All staff with the surname beginning with A are placed in the tab labeled "A"
All staff with the surname beginning with B are placed in the tab labeled "B" and so on....
What I want to know is, is it possible to change the code given to me previously in order for it to work on all pages as at the moment it only works on tab A.
I have tried simply copying the code into tab B and changing the variables at the top and as far as I can tell it hasnt worked unless i've done something wrong.
Code being used in tab A.
Up to date copy of a slimmed down version of the workbook below.Please Login or Register to view this content.
Bookmarks