Recent content by teebird

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 :-)