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 MeGustaXL

  1. MeGustaXL

    Determined, Decided or something else?

    Thanks guys... I settled on "Based on a review of the previous Report, the Big Boss decided that..." Much better [bigsmile] Chris Someday I'll know what I'm donig...damn!
  2. MeGustaXL

    Determined, Decided or something else?

    Review of the previous report decided (determined) that the following actions should be taken in future..." Suggestions/recommendations? Chris Someday I'll know what I'm donig...damn!
  3. MeGustaXL

    Father Of The Bride Speech

    Hi, My daughter's getting married later this year, so I'm starting my Father Of The Bride speech. Any hints/tips/jokes or special lines I can use? Chris Someday I'll know what I'm donig...damn!
  4. MeGustaXL

    Dynamic MATCH function range

    Hi strongm, I'm sorry I didn't reply sooner, but we were sidetracked to another project and now off for Christmas. I'll try it out during the break and get back to you ASAP OK? Thanks for helping, and have a merry Christmas and Happy New year 😊 Chris Someday I'll know what I'm donig...damn!
  5. MeGustaXL

    Dynamic MATCH function range

    Hi, In a table of data, I'm using INDEX-MATCH to return a value from the Header_Row, based on the column of a Target_Value. With a fixed Search_Row, the formula is: =INDEX(Header_Row,1,MATCH(Target_Value,Search_Row,-1)+1) This works perfectly. [thumbsup] But, the table has 10 rows, with...
  6. MeGustaXL

    XL2010 Data Validation List - Searchable Dropdown

    Hi Guys, Any ideas on how to make a Data Validation Dropdown list searchable, ie Auto-Complete? I've got the DV list set to a list on another sheet called "DV_LIST" and it all works great, except that DV_LIST contains 235 items, and scrolling down leads to folks just picking the nearest match...
  7. MeGustaXL

    Pivot Table Conditional Formatting in XL2010

    Hi Andy, I know what you mean, but as I learned a lesson from this, I decided to share that lesson with the Tek-Tips Family [thumbsup2] Chris Someday I'll know what I'm donig...damn!
  8. MeGustaXL

    Pivot Table Conditional Formatting in XL2010

    Forget it! My bad, I was putting quotes around the criteria words and phrases, which it turned into formulas and....D'Oh Chris Someday I'll know what I'm donig...damn!
  9. MeGustaXL

    Pivot Table Conditional Formatting in XL2010

    Why won't my Conditional Formatting Rules apply in a Pivot Table field? Chris Someday I'll know what I'm donig...damn!
  10. MeGustaXL

    XL 2010 Pivot Table Refresh Error

    Skip, Sorry for the delay but we've been diverted for the last few days. Tweenster and I have tried the Missing Items property and clearing the Pivot Caches, manually and by VBA, but the error still occurs every time the WS is opened. Any chance it could be due to the sheer gigantic size of the...
  11. MeGustaXL

    XL 2010 Pivot Table Refresh Error

    Thanks Skip, tried that and it Refreshed them all nicely, but closing and reopening still kicks off a repair of PivotTable8, even though the entire tab with it on has been deleted [thumbsdown] Chris Someday I'll know what I'm donig...damn!
  12. MeGustaXL

    XL 2010 Pivot Table Refresh Error

    Hi, My workbook has a total of 19 Pivot Tables, linked to various Data Tables. When I do a "Refresh All", a message pops up saying that "This Pivot Table is invalid...." When I close and reopen the workbook, it gets repaired because of an "Invalid Pivot Table", and the xml report points to...
  13. MeGustaXL

    IE11 - Country Problems

    Hi, I'm in the UK, but my computer connects via a US-based server. This often brings up unwanted/irrelevant search results and form autofill results. To complicate matters further, my IP is interpreted by Google as being in Germany! Several websites don't work properly for me because they...
  14. MeGustaXL

    Excel 2010 Chart with Log Scales

    Thanks combo [2thumbsup] That's the reminder I needed! No need for XY Chart Labeller (fantastic though it is) Chris Someday I'll know what I'm donig...damn!
  15. MeGustaXL

    Excel 2010 - convert date to six-digit string

    Hi Skip, Star for you too, as I gave my (other) friend a medal...you must've posted almost at the same time as me! Chris Someday I'll know what I'm donig...damn!
See more

Part and Inventory Search

Back
Top