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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by teebird

  1. teebird

    Excel - Paragraph of text in one column broken up into 4 columns

    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]
  2. teebird

    Excel - Paragraph of text in one column broken up into 4 columns

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

    Excel - Paragraph of text in one column broken up into 4 columns

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

    Internet Explorer displays blank page

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

    Internet Explorer displays blank page

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

    Outlook 2003 Personal Calendars

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

    Parition external drive

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

    Parition external drive

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

    Option Buttons and Code

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

    Option Buttons and Code

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

    Option Buttons and Code

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

    Option Buttons and Code

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

    Option Buttons and Code

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

    Option Buttons and Code

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

    Sharepoint - Group list on A then B, then C etc.

    thanks :-)
See more

Part and Inventory Search

Back
Top