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 Chriss Miller 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: xlhelp
  • Content: Threads
  • Order by date
  1. xlhelp

    OT: I could be wrong...

    and if I am... I apologize. But, Skip...... isn't your your birthday around this time of the year? Avoid Hangovers. Stay drunk.
  2. xlhelp

    OT: Fumei

    Gerry. With only a few hours left in your retirement, I thought I would pounce upon the opportunity to wish you Happy Retirement. Since you don't subscribe to the internet at home, I presume we will not see you on these fora that often. Happy Star Gazing, Happy Sclupting and Happy Painting...
  3. xlhelp

    XL - Cerebral Flatulation...

    It should be simple but, I can't seem to think beyond a certain point. I have "Yes" or "No" in column F and I have a text string in column B. If the cell in column F is a "No" then I want verify that either "NoBill" or "No-Bill" is part of the text in the respective cell in column B. So far no...
  4. xlhelp

    Compare Two Worksheets

    I had to compare two worksheets with identical columnar data with approximately 500 rows in each worksheet. I searched for solutions and although I didn't persist, all I could find was add-ins or third-party software. I found a way fo comparing two worksheets with small differences in data...
  5. xlhelp

    Cannot delete file

    Hi, I have Windows Vista Home Premium Edition. All of a sudden I am having problems deleting files from Windows Explorer or Recycling Bin. Doesn't happen with all files, only some and they are still there. I get a dialog box with "Discovered 0 Items (0 Bytes)" and it keeps on running through the...
  6. xlhelp

    Boolean Operators (Chicken or the egg type of question)

    When running queries (or Searches) is there a difference in speed when using AND followed by OR versus OR followed by AND. In one of our databases putting an OR seems to cause major pain. Since I am not quite sure of which works better, I thought I would toss the question out to see if someone...
  7. xlhelp

    Excel Background Image Formatting

    This is probably a rhetorical question, but I thought I would ask anyway. One of my students asked if there is a way to adjust the tiling in the background image that you can insert in a spreadsheet. (Pre 2007 - Format, Sheet, Background; or 2007 - Page Layout, Background) I usually advise...
  8. xlhelp

    Excel - (Data Validation) ListBox Height

    Hi. Does anyone know if there is a way to increase the listbox height. I have 10 items to choose from, listbox shows only 8. I have searched, but have had no joy, so far. (XL 2003) A man has only two choices: He can be right or he can be happy.
  9. xlhelp

    Bulleted Lists in Excel

    This has also been submitted as FAQ: [Link javascript:openindex(450,450,'http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=450')]FAQ68-7219[/url] Bullet in a single cell: This one is easy. Most people know about this one. Place your cursor at the beginning of the cell; hold the ALT key...
  10. xlhelp

    Excel indent question

    Does anyone know how to do a hanging indent in a cell? I already know about typing spaces, but when there is fair amount of text, that becomes cumbersome. (Using XL2003 but,I am pretty sure that if there is an answer, it would be version independent) A man has only two choices: He can be...
  11. xlhelp

    Cannot Copy Tables with objects

    Hi. I am using version 6.5.5. When I copy a table with objects (mostly Symbols) and paste it in Word or Powerpoint, I only get the text. What am I doing wrong? Thanks I don't particularly care about apathy
  12. xlhelp

    XL: Get months from last year & this year in sequence

    Hi, I am having one of those cerebral flatulations. I want to create a Pivot table of data from 10 months of last year and 2 month of this year in a sequence. That is January follows Dec and Data table starts at March. My results are always Jan, Feb, Mar... etc. So, what am I doing wrong...
  13. xlhelp

    @DocumentUniqueID

    Hi, I need to grab @DocumentUniqueID somehow copy it to clipboard and paste it in another application. I have tried various combinations of @Text..... @EditCopy...., but no success. Can anyone help with exactly what I need in a macro? I right click, click doc properties, highlight unique id...
  14. xlhelp

    OT: Skip

    Hey, Skip. Compliments on sticking it out with us guys for last seven years. Wish I had your kind of dedication. Here's to (at least) seven more years. Hope you have a great Christmas, just in case I don't get on board again for a while. Vita Brevis
  15. xlhelp

    Windows has recovered from an unexpected shutdown.

    My system seems to have a bounus feature on it. Once a day it reboots and one logged in, up pops up the message above. And every other time, the screen resolution goes wonky. Hp has a fabulous solution for this. Perhaps, one of their five year old child came up woth it. "Turn of your system...
  16. xlhelp

    XL 2007 - Another Chart Question

    In Excel 2003 when I plot a chart, I can cycle through all the elements of the chart through arrow keys on the keyboard. Why doesn't that work in 2007? Am I doing something wrong? Have I lost that many brain cells? I would really appreciate any answers from the many maestros there are now on...
  17. xlhelp

    XL 2007 Chart - Data Label frustration

    Hi. I am plotting a stacked bar chartfor the following values: Rent $750.00 Food $400.00 Travel $220.00 Savings $150.00 Entertainment $200.00 Utilities $280.00 I am trying to add Data Labels to all data points in one step. The amazing MS product let's me insert...
  18. xlhelp

    Q: Office 2007 and Office 2003 on Vista

    Hi. I have a system with Vista and office 2007 on it. I want to be able to install Office 2003 as well, seeing how 2007 is so unique. Anyone have any experience with it? I have heard no matter what, 2007 erases old installation when it runs or when you run either version it wants to re-install...
  19. xlhelp

    XL: Hide chart labels if value Zero

    Hi. I haven't found a way yet. I have four stack column chart where some of the values in the stack are Zero. I wish to label the stacks with Series name, but want to hide the label if the value is Zero. Anyone ever come across something like this? Thanks Member- AAAA Association Against...
  20. xlhelp

    Reverse of WEEKNUM

    In my calculations I needed to get the date for the first day of the week knowing only the week number. What I came up with is the formula below. There may be a better approach than mine and I would love to find out if there is. And, yes I do know about Date + 7...

Part and Inventory Search

Back
Top