Search results for query: *

Hi Skip Have followed your steps (the dynamic name ranges is great thanks) and the information comes through to the sheet. Appreciate your assistance and guidance. I have 2 questions though: 1. I still need filtering for "Completed" (date field) is null. Would you add the filter in the...

Hi Skip yeah just got into work logged in and realised the inconsistencies in what I pasted.... sorry. It was late when I did that. Thanks will give this a go today. Cheers Adam72 is Australian... does that explain it?? Every day you wake up is a good day... just remember the alternative!! :-)

hmmm didn't seem to work last time I tried so here goes.... Priority Name Brief Due Dates For Description % Complete Completed 1 Adam Key Dates 1/08/2010 EIM Calendar of key dates to create understanding of scheduled data requirements 40% 1 Adam Annual Review 15/08/2010 EIM Facilitate the...

Hi Skip I have uploaded a copy of the file (easier than me trying to type in a sample) I am using with some temp data in there. I need the macro to take the data from the workplan list and push it to the workplan allocation report. Thanks Adam72 is Australian... does that explain it?? Every...

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...

Okay results were as below. Name Skip Duane Andy Test ONE ONE ONE ONE Test Tester TWO TWO TWO TWO TWO TWO TWO TWO Test D'THREE D'THREE D'THREE THREE Test Tester FOUR-FOUR FOUR-FOUR FOUR-FOUR FOUR Test FIVE FIVE-FIVE FIVE FIVE-FIVE FIVE FIVE-FIVE FIVE FIVE Test-Tester SIX SIX...

hmmm upload of file not working... sorry Adam72 is Australian... does that explain it?? Every day you wake up is a good day... just remember the alternative!! :-)

Hi All (again) My thanks goes to you all, it has been great to get so many responses in a short amount of time. But in the end I had to go with Skip's solution as it was the more robust when placed against my testing names (see attached). Skip, any chance you could give me a quick run down of...

Hi All Thanks for your replies. To answer the question: The extraction process converts the surname field into capitals before the concatenation, so yes the surname is always in capitals even when it should be in lower eg van der Veldt or de Bertoli. The givennames are always in 'Propercase' eg...

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...

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...