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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Sopman
  • Content: Threads
  • Order by date
  1. Sopman

    Turn Tracking feature off in a .doc

    When I open a .doc it shows all the changes that everyone has made in red. I'd like the .doc to open without showing the changes. I went to Tools-Options-Edit and removed the check mark in "Keep Track of Formatting". The .doc still opens showing the changes. Thanks Sopman
  2. Sopman

    Email Addresses in Access

    I have a field that contains email addresses. Is their a way to get the email addresses in access into Yahoo mail? I tried saving them in excel as a .csv file, but could not import them into yahoo mail. Sopman
  3. Sopman

    Calculating a Players Age

    I'm keeping the database for little league. In "Forms" I have fields labeled "birthday", "league age", and "Apr 15, 2007". What I would like to do is when the birthdate is enter I need that to subtract from Apr 15, 2007 to give me the league age of the player. Is there a way to calculate this...
  4. Sopman

    Exporting Personnel Address Book

    I'm trying to transfer my MS Outlook Personnel Address Book (.PAB) into my Yahoo email account. I'm having troubles making the .PAB into a .CVS so that yahoo can import it. I don't want to import my "Contacts", just my Personnel Address Book. Can someone help me? Sopman
  5. Sopman

    Excel "Lookup" Command Problems

    In my Excel spreadsheet I have a separate sheet that has the "Lookup" values. This sheet is called "Data". On a different sheet I have this command, =LOOKUP(K6,DATA!K5:K400:DATA!L5:L400) The value I had in K6 use to match up correctly with what was in the "Data" sheet. Everything worked...
  6. Sopman

    Excel Offset/Count Command

    Somedays have data in cells A1,A2,A3,A4,A5,A6 Somedays I have data in A1,A2 Somedays I have data in A1,A2,A3,A4 I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which...
  7. Sopman

    Excel Lookup Formula

    Somedays have data in cells A1,A2,A3,A4,A5,A6 Somedays I have data in A1,A2 Somedays I have data in A1,A2,A3,A4 I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which...
  8. Sopman

    Excel Format Question

    In cell "A1" I have a date "7/13/2006" In cell "B1" I have a time "1:45 PM" How do I combine both columns into one column with a "space" between the date and time? Thanks Sopman
  9. Sopman

    Excel Counting

    In column 'A' I have numbers 1-48. Is there a way to reverse those number and put them into column 'B'? Can I use the Paste Special? Sopman
  10. Sopman

    Sorting in Excel

    I have a spreadsheet that has the schedule of basketball games/practices for all teams. Is there a way to sort out just our team? We are team 5. In column E this is what it looks like: Game 2 & 5 Plus it has other teams playing: Game 3 & 4 Thanks Sopman
  11. Sopman

    Windows Explorer

    I'm trying to do the Search command "containing text", but having problems with the text I'm entering. It is ##.00 For some reason it doesn't like the #. I get a parameter error message. Is there anyway around this? Thanks Sopman
  12. Sopman

    Excel Macro's

    I'm a user on a network. I had to rebuild my profile. We renamed the old profile, so I still have it. I've lost all my macro's in excel. Does anyone know what file I need to transfer over to the new profile to get my macro's? Sopman
  13. Sopman

    Repair an Excel File

    I have an excel file on floppy that I can't open, move or copy. I've tried DOS xcopy, Advance Excel Repair v1.4 (from the internet. Does anyone know of a good repair file software for excel 2000? Sopman
  14. Sopman

    Excel Format Question

    In column "A" I have the date, ie: 1-May, 2-May, etc. In Column "B" I'd like the day, ie: Sunday, Monday, to match the date. Can you help? Sopman
  15. Sopman

    Updating Charts Automatically

    I'm able to use the Offset in the Insert-Name-Define to update my chart automatically, which has multiple lines, but my legend doesn't display the title for each line. It only comes up Series 1, Series 2, etc. Is their a way change the legend to reflect what each line represents on my data...
  16. Sopman

    Excel, Moving Cursor after hitting Enter

    Is there a way after entering data in column "J" to hit 'enter' and have the cursor move down one row and to column "B" for multiple entries? Sopman
  17. Sopman

    Excel Date Format Question

    I have about 300 entries to put into a spreadsheet with differents dates. I would like to enter the date like 031005 and have it be displayed as 03/10/05. I tried Format-Cell, but it converts it to a different date. Is there a way to do this? Sopman
  18. Sopman

    Haven't seen this problem

    I have Office2000. I'm not sure what happen, but in an excel spreadsheet my file looks like someone click on the box in the upper right-hand corner to size the spreadsheet. I put the mouse on the edge of the file to size it, but I don't get the double arrow. Also, I can't drag the title bar...
  19. Sopman

    Export PAB

    In Outlook2000 is there a way to export the PAB (Personal Address Book) into excel? I can do the contacts, but they are not the same. Thanks Sopman
  20. Sopman

    Excel formula Question

    How do I count up the "R" that will be put in one row, but in different columns? Columns will consist of number of days in a month. So if the 2nd, 5th, 12th and 22nd days have an "R" in them, what formula would you write to get it to add up to 4? Sopman

Part and Inventory Search

Back
Top