Search results for query: *

Hi Gruuuu WOW excellent many thanks. I am not at work today but on Monday I will set up the columns with your code. Really appreciate it - I did try but just do not have enough understanding of functions to make the logic work. Again many thanks Teebird. [smile]

Many thanks everyone for your help with this. @ Gruuuu The data in the brackets changes but the spaces and headings eg. Issues Identified: remain the same. Cheers Teebird

I have one column of text that I want to separate the text into 4 columns. Column 1 contains all the text including the date 16/03/2012; Issues Identified: high blood pressure Referral/Action: Sent to GP Problem List Updated? No Recalls added? Yes new recall for BP Column 1 Issues...

thanks for getting back to me - I have IE8 - tried what was suggested but it is still not working - will take my pc into the IT techs in town. thanks again Tee.

Hi All I am using Internet Explorer and recently on some webpages, when I go to login - for example ANZ Bank - when I tried to use the logon page - all I am getting is a blank page and the hours glass. This is also happened on other sites. Not necessary the login boxes - even just clicking on...

Hi All I have setup some personal calendars in Outlook under a generic logon. I would like to share these "personal calendars" with another person with a different logon. Both parties are on the same network. I have managed to share the default calendar but the other person is unable to see...

Hi All Many thanks for your replies. I did not know that Win 7 had that feature. Great I will try to do it now. Thanks again. Tee

Hi All Does anyone know of an open source product that is free to partition a WD My Passport Essential external drive. It is 500GB and I want to break it up into 2 250GB drives. Any recommendations on whether it should be Fat32 or NTFS... Many thanks Tee

Hi Skip I did the name ranges as you suggested. Now - When I select PROF (option button) - I get #VALUE! in Cell N6 and when I select ADMIN (option button) - I get P1. I should be getting AO2. I have uploaded another file. MY-Table-21-03.xls Thanks again Tee...

Hi Skip Have removed the spaces,corrected the spelling, as I am using Excel 2007 so I cannot named the ranges as you suggested. I have tried a couple of ways to name them but I still get errors. when I click option button Prof - I get #VALUE! in Cell N6, when I click option button Admin - I...

Hi Skip thanks for your perseverance... I have uploaded another spreadsheet - I think I have done anything. But still get the #NAME? error. Cheers. Tee. https://freefileserver.com/file/259/MY-Table-xls.html

Hi Skip Many thanks for your reply...sorry ...I am a bit lost. I have replaced the option buttons with Form Option buttons and linked them to obPosition (Cell M6). When I changed option buttons now - I get either a 1 (Prof) or a 2 (Admin)in Cell M6. I have setup my named ranges like you have...

Apologies for the confusion. I have included a sample spreadsheet - hope this helps. Many thanks for your assistance. Tee.https://freefileserver.com/file/254/MY-Table-xls.html

Hi All I have a number of lookup tables (named ranges) on Sheet3 Named Range Column 1 - Column 2 - Column 3 Admin . . . . . . . . .AO1 . . . . .0 . . . . . . .50 . . . . . . . . . . . . . AO2 . . . . 51 . . . . . 100 Prof . . . . . . . . . .P1 . . . . . .0 . . . . . . . 50 . . . . . . . . . ...

thanks :-)

Hey thanks for that. I will try it now. Tee.

Hi All Does anyone know how I can group a list of names under each letter of the alphabet. So my list will display with the 26 letters of the alphabet and when I expand the A folder, all names starting with A are displayed. A - A1, A2, A3 B - B1, B2, B3 C - C1, C2, C3 etc.. Many thanks Tee.

Hi All many thanks for your replies. I tried to Windows Search but found it too resource hungry. Not sure if work would appreciate me changing the registry on their machine. I was more looking for the logic behind how Windows searches in simple language as my work colleague is not very IT...

Hi All I am having abit of a discussion with a work college about how Windows performs a search. If there are 2,000 records in a folder with different and same modified dates - and I ask Windows to search on date modified eg. 01/01/2010 to 21/01/2010. I may do this many times looking for...

Hi All I am trying to setup in Excel a spreadsheet that will once I enter the nett wage figure in one column, it will automatically give me a breakup of the number of $100s, $50s, $20s etc - and then I can give a summary to the bank for staff wages. Net Wage $100 $50 $20 .50c .20c $450.20...