Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating Report from Working list
Hi I have my working list (sheet1) with column headings of Priority, Name, Brief, Due Date, Dept, Description, % Completed and Date Completed. Whilst I filter this while assigning tasks i need to create a report to show all the peoples incomplete work, to print out on 1 page for a meeting...- Adam72
- Thread
- Replies: 9
- Forum: Microsoft: Office
-
Code to extract surname
I have an excel file which contains the full name of clients which has already been concatenated, and need to extract the surname back out of the string to be able to sort alphabetically on surname. The names are in the following format: Givenname Givenname SURNAME Givenname SURNAME etc To...- Adam72
- Thread
- Replies: 27
- Forum: Microsoft: Office
-
Code to extract surname from cell
I have an excel file which contains the full name of clients which has already been concatenated, and need to extract the surname back out of the string to be able to sort alphabetically on surname. The names are in the following format: Givenname Givenname SURNAME To allow for instances where...- Adam72
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
