+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 201 to 352 of 352

Call in the Cavalry - 2014

  1. #201
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    If you Google: excel vba worksheet rename event ... you get a few suggestions, mostly from other forums though so I hesitate to provide links.

    It's a bit of a botch up but it looks like it could be done.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  2. #202
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    You could count the characters in the tab and, if deficient, issue your message or repair it right there!
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #203
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    Counting characters alone wouldn't be enough; you'd need to check the content/structure, perhaps with a Regular Expression. But what would prompt you to check it?

    Best bet would be to lock the workbook structure and have button to create new sheets.

    Regards, TMS

  4. #204
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    Please Login or Register  to view this content.
    ???

  5. #205
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    But what would prompt you to check it?
    Day and Month could be in the wrong order, the Year could be two digits. Missing/extra hyphens ...

  6. #206
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    Hey Trevor, the OP's post just shows omissions in the two digit month field

  7. #207
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    I think not. Look again. At least two no-no's but I suspect lots more possibilities.

  8. #208
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    Hi Trevor,

    I looked again: You're right but

    Length 9=> omitted first zero
    Length 8=> omitted the 20 for the year
    Length 7 => omitted both

    You could still work with it!

    Probably easiest would be to format it "mm-dd-yyyy".

  9. #209
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    Well I played with the notion but, with appropriate safeguards:

    Please Login or Register  to view this content.
    works rather nicely
    Last edited by xladept; 07-03-2014 at 04:17 PM.

  10. #210
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2014 onwards

    op wants to fill in an allocation table and update a planner OR update the planner and it fills out the allocation table cant really see the second bit myself, any ideas peeps?

    http://www.excelforum.com/excel-gene...orksheets.html
    Last edited by martindwilson; 07-02-2014 at 07:53 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  11. #211
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Call in the Cavalry - 2014 onwards

    Hi Martin,

    can't see which thread you are referring to.

    Pete

  12. #212
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2014 onwards


  13. #213
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Call in the Cavalry - 2014 onwards

    Seems an array formula is required in this thread... Any suggestions, Sktneer?

    Take part information from a cell to create a formula
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  14. #214
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Call in the Cavalry - 2014 onwards

    Looks like another array formula is required for the OP of this thread : Formula Not Recognising Cells as Blank with Formulas that Return Empty Text

  15. #215
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Call in the Cavalry - 2014 onwards

    Any ideas for the OP's requirement in this thread? Calculations based off formula from another cell

  16. #216
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    Anyone have time to look at this? I just don't seem to be able to get my head around the requirement.

    Counting the number of occurrences before the current week #


    Thanks TMS

  17. #217
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Call in the Cavalry - 2014 onwards

    Trevor,

    looks like he had his " in the wrong place.

    Pete

  18. #218
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    @Pete: thanks for looking ... wood for trees and I don't think the workbook helped me much

  19. #219
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Call in the Cavalry - 2014 onwards

    Can anybody extend help for the OP in this thread ?? : Depleting From Multiple Values At Once

  20. #220
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Call in the Cavalry - 2014 onwards

    I'm not sure if my nesting 24 =SUBSTITUTE()'s is really the best way to go about this problem, any help for this op?

    http://www.excelforum.com/excel-gene...haracters.html
    Last edited by Speshul; 07-15-2014 at 03:05 PM.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  21. #221
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2014 onwards

    This OP is trying to understand why his (IMO erroneous) number format gives a different display in the spreadsheet than in the chart. I cannot really confirm his observations in my own version and I don't have 2013. Any takers?

    http://www.excelforum.com/excel-char...ts-y-axis.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  22. #222
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Call in the Cavalry - 2014 onwards

    Can someone help with this mailmerge problem. OP is unable to upload file. What he wants to do is produce letters to each of 1500 employers to 9000 employees based on who the employer is. A Word problem perhaps but I think he's right by raising the question here because of the need to manipulate the data document in Excel.

    http://www.excelforum.com/excel-gene...ail-merge.html
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

  23. #223
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    OP is trying to use hyperlink() function with root paths which have more than 255 characters.

    But unfortunately the Link Location argument of Hyperlink() function accepts maximum of 255 character length only.

    Any suggestion will be helpful to the OP

    http://www.excelforum.com/excel-form...mla-value.html


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  24. #224
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2014 onwards

    OP asked for something "brutally simple", so I suggested a filterable list using Autofilter. I don't do "database" stuff, so I haven't got much more to suggest to him. http://www.excelforum.com/excel-gene...iles-here.html

    Can anyone suggest another approach?

  25. #225
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Anyone with access to EXCEL 2003, can you download the workbook solution I've provided in this thread and see if you're seeing the same issue the OP is seeing. We are applying an Autofilter to a range based on a search string typed in H2.


    Here's the file in case you don't have access to that thread.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  26. #226
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Call in the Cavalry - 2014 onwards

    I have stepped in something terrible. Pretty sure its programming related.

    Please Login or Register  to view this content.
    https://www.excelforum.com/showthread.php?t=1028374
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  27. #227
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    Hi Jerry,

    What I found to be weird about the demo file is that each criterion is listed in every first few cells in the H range - otherwise it seems to work
    Last edited by xladept; 07-31-2014 at 06:07 PM. Reason: Typo in body

  28. #228
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Call in the Cavalry - 2014 onwards

    @JB,

    I believe this will resolve issue:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  29. #229
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    Anyone have experience of refiltering OLAP pivot tables with VBA / parameters?

    http://www.excelforum.com/excel-prog...-function.html

    Reading http://support.microsoft.com/kb/234700 would indicate that normal methods of refiltering pivots won't work - as I've found, eventually, after going through all the usual steps of trying to get code to work...

    Anyone?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  30. #230
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2014 onwards

    This is worksheet change event and it is a bit out of my wheelhouse. Hopefully, you can get the OP on the right track.

    http://www.excelforum.com/excel-prog...er-column.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  31. #231
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    This OP is created an excel file by referencing the formulas to the desktop file. The issue is that the desktop root path will get differed to each persons which is creating an issue by showing the Update Link popup message.

    OP looking for automatic adjustment of desktop link in formulas.

    OP is eagerly waiting for the solution for this issue.

    http://www.excelforum.com/excel-gene...reference.html

  32. #232
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Call in the Cavalry - 2014 onwards

    I tried a few things but couldn't get it to work....anybody?

    thanks

    http://www.excelforum.com/excel-prog...in-column.html
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  33. #233
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards

    Requires Array formulas and no helper columns

    http://www.excelforum.com/excel-form...condition.html
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  34. #234
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Call in the Cavalry - 2014 onwards

    Hi all,

    Any ideas for forcing this formula to re-calculate in Automatic Calculation mode?

    Usually just an additional clause, e.g. with NOW(), forces the issue, though I can't get anything to work here.

    Cheers

    http://www.excelforum.com/excel-form...ml#post3796764
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  35. #235
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2014 onwards

    Anyone want to help out with this 1?
    http://www.excelforum.com/excel-form...to-column.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  36. #236
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2014 onwards

    Any one have any idea why the code in this
    Thread will not work in 2013 works fine
    In 2007
    http://www.excelforum.com/excel-prog...onversion.html

  37. #237
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Call in the Cavalry - 2014 onwards

    @Martin

    I think the problem is you have a reference to the solver in your workbook that will probably be missing in 2013. So the str() and trim() functions will be undefined. You need to either remove the reference or add a parent to the str/trim (e.g. conversion.str / strings.trim)

  38. #238
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    @Martin: I couldn't find the reference so I just unticked the MISSING Solver.xlam reference. Compiled OK after that with no other changes.


    And, as it implies, 79228162514264337593543950245 is the highest number but you need to convert it with:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    which returns: 111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110100101

    Regards, TMS
    Last edited by TMS; 08-12-2014 at 07:12 AM.

  39. #239
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    OP gets a Type Mismatch error in response to a Message Box

    In this Thread OP gets a Type Mismatch error in response to a Message Box. I've tested in Excel 2007 and 2010 and the Code performs as expected. OP uses Excel 2013 and is receiving Error 13.

    Any of you with Excel 2013 have time to look? Thanks.

    http://www.excelforum.com/excel-gene...ml#post3800110

    Note to Mod/Admin...I posted to the wrong Sub Forum. Would you please move to Call In The Cavalry.
    Last edited by jaslake; 08-13-2014 at 11:23 AM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  40. #240
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Call in the Cavalry - 2014 onwards


  41. #241
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Call in the Cavalry - 2014 onwards

    This should be a simple "count if" but I'm just not understanding the OP's requirements.

    Need a fresh set of eyes on this one:

    https://www.excelforum.com/showthread.php?t=1031643
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  42. #242
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Call in the Cavalry - 2014 onwards

    I think the OP said you solved it with one small change to your last formula?
    Remember what the dormouse said
    Feed your head

  43. #243
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    This is going to be a simple AND() Function usage but I am unable understand the OP's requirement

    Anyone please help with this below thread

    http://www.excelforum.com/excel-form...of-values.html

  44. #244
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Any Google Docs oficianados care to take a glance at this one, OP is trying to use INDIRECT() which is supposedly a usable GD function.

    http://www.excelforum.com/for-other-...-formulas.html

  45. #245
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Pulling from 2 dimensional array


  46. #246
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards


  47. #247
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Call in the Cavalry - 2014 onwards

    Not sure on this one, I think it's possible but my attempt is giving me confusing results.

    http://www.excelforum.com/excel-form...ml#post3814241

    He wants to rank by the Average of each row, but within one formula per row (no helper columns).

  48. #248
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards

    I think this one will require laying out the data as the OP suggests or VBA but I'd love to see a formula solution

    http://www.excelforum.com/excel-gene...ertically.html

  49. #249
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Call in the Cavalry - 2014 onwards

    Hi all.

    Didn't notice that the OP had posted to the VBA section on this one, so offered a formula-based solution, which turns out to be inappropriate for the size of the dataset that the OP has.

    Said I'd bump it for them to anyone with expertise in VBA and willing to have a go.

    http://www.excelforum.com/excel-prog...al-amount.html

    Thanks a lot.

  50. #250
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Call in the Cavalry - 2014 onwards

    As far as I can understand with this question, I solved it in post #3.. It is now on post #25. Can someone else take a look at this, before I lose my mind?

    http://www.excelforum.com/excel-gene...me-cell-2.html

  51. #251
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards

    Busy with other projects, won't be on here much for a bit. Can someone take this one?

    http://www.excelforum.com/excel-gene...-a-series.html

  52. #252
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Call in the Cavalry - 2014 onwards

    This was more than I expected from the OP....anybody want to give it a go?

    http://www.excelforum.com/excel-prog...ml#post3824784

  53. #253
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Call in the Cavalry - 2014 onwards

    Lord have mercy. Someone. Please. Help.

    http://www.excelforum.com/excel-gene...ml#post3826744

  54. #254
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by XOR LX View Post
    Lord have mercy. Someone. Please. Help.

    http://www.excelforum.com/excel-gene...ml#post3826744
    I've tried...

  55. #255
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Anyone with ADO connectivity experience that can comment on this thread?

    Op is trying to read text from closed workbooks, and apparently the text is huge per cell, they need to be able to pull out more text than 255 characters, and the workbook takes too long to actually open/close.

    Any help at all is appreciated, I have no exp with ADODB connections and pulling large text from closed workbooks.

  56. #256
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    This one is going to be a simple formula logic but understanding the logic is something very hard to me.

    Anyone please jump in this thread to solve this OP's issue

    http://www.excelforum.com/excel-form...-are-true.html

  57. #257
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Call in the Cavalry - 2014 onwards

    Does anybody understand this 'cause I don't

    http://www.excelforum.com/excel-prog...the-macro.html

  58. #258
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards


  59. #259
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    No idea what could be causing this - anyone encountered anything similar before?

    http://www.excelforum.com/excel-prog...-cut-keys.html

    Macro apparently runs fine when called directly, but "just stops" part way through when called via keyboard shortcut...

  60. #260
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    I'm inexperienced at the connections changes this thread is dealing with, can anyone offer suggestions I cannot?

  61. #261
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2014 onwards

    Since I just use Rob Bovey's chart labeler add-in, I'm not very familiar with the code behind it, and this OP claims that he cannot use third party add-ins for the task. If he needs further help developing the procedure for this, can someone step in and help him?

    http://www.excelforum.com/excel-prog...ta-labels.html

  62. #262
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Call in the Cavalry - 2014 onwards

    I think this OP has basically filled out the "make lookups harder" bingo card.

    1) Two-column lookup to return third column
    2) Indeterminate column depth, maybe
    3) Return multiple matches?
    4) Check all the worksheets for matches

    I'm a little too intimidated to even ask questions to specify the things I'm not sure about, and get kinda, committed to answering.

  63. #263
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    @ben_hensel: not sure there's a barge pole long enough with a description like that. Good of you to highlight it though

  64. #264
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards

    Yeah, I read that and moved on too. My brain can't handle it today.

  65. #265
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-prog...logy-tool.html

    I've exhausted my ideas for this OP's request. You got any?

  66. #266
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-char...eto-chart.html

    this OP says that she really wants a pivot table solution. I expect it can be done, but I have no experience with pivot tables. I think the solution I proposed will work, but, if anyone who knows pivot tables could chime in and show her how to do it with a pivot table/chart, it could be a better solution.

  67. #267
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    On behalf of xladept:

    Can anyone help with this concept?

  68. #268
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards


  69. #269
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Dependent Drop Down lists - INDIRECT()

    Dependent Dynamic Drop Down Lists - OFFSET()

    The OP in this thread is searching for a way to do it without either of these functions, which I have never found.

  70. #270
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards

    If anyone wants to jump in on this one, I wouldn't complain.

    http://www.excelforum.com/excel-form...combining.html

  71. #271
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    @ChemistB - no thank you/dynamic requirements

  72. #272
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    A simple form question has stumped us, trying not to need the OP to post the form... guess I should just do that.
    http://www.excelforum.com/excel-prog...-text-box.html

  73. #273
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    A pretty advanced topic, IMO, thought I'd draw some more eyes to it.

    http://www.excelforum.com/excel-prog...t-methods.html

  74. #274
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by JBeaucaire View Post
    A pretty advanced topic, IMO, thought I'd draw some more eyes to it.
    I came across that thread and if we resolve the current issue (Disabling the Insert/Delete From Right Click) then the next question will be disabling the Ctrl++ and Ctrl+- from the Keyboard which requires Application.Onkey method.

    Even if we do that then the next question will be raised from the OP that this should happen on that sheet alone. So we have to enable the Application.Onkey on deactivation which needs lot of follow-ups, so I thought to stay away from that thread

  75. #275
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    Can anyone have a look at this please: Delete fifth Name

    I provided a relatively simple formula solution to extract the first four elements (space separated) from a cell.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    And the OP seemed OK with that but then came back with a much more complex formula that he wants/needs to adapt.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Lost on me, I'm afraid.

    Thanks, TMS

  76. #276
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    Odd problem here - unable to refresh data queries on a protected sheet, despite unprotecting first, or protecting with userinterfaceonly=true...

    http://www.excelforum.com/excel-prog...ry-tables.html

  77. #277
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Calling once again, this OP has pinged looking for assistance on his one request, promising not to feature creep anyone. I've no idea or would jump in...

    http://www.excelforum.com/excel-prog...t-methods.html

  78. #278
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    I used this code for dependent drop down list (Validation) based on the selection the next validation cell will be cleared and I used the sendkey method to auto populate the drop down.

    Please Login or Register  to view this content.
    But this is not working in MAC excel and throwing some errors to the OP.

    After doing some google search I got the below link and I found the send key method for MAC excel and used it in the below code.

    http://www.mrexcel.com/forum/excel-q...dkeys-mac.html

    Please Login or Register  to view this content.
    But unfortunately this also not working for the OP

    Anyone have any suggestions? If so, then please join in the below thread

    http://www.excelforum.com/excel-prog...r-changes.html

  79. #279
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Any suggestions for updating hardcoded hyperlinks to broken destinations?
    http://www.excelforum.com/excel-gene...auto-save.html

  80. #280
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Something for the FORM wizards...
    http://www.excelforum.com/excel-prog...a-project.html

  81. #281
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    Anyone have any suggestion about what's going wrong in JapanDave's code?

    http://www.excelforum.com/excel-prog...n-columns.html

  82. #282
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-prog...-with-vba.html

    I THINK the OP wants to resize a workbook window, within the (maximized) Excel application window. I only have 2013 on this PC, where every workbook opens in it's own Excel instance.

    Anyone able to help?

  83. #283
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Anyone care to pipe in here?

  84. #284
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    @JB: I think not. I have a mental picture of the thread with little round "bruises" all over it. That would be from the barge poles touching it.

  85. #285
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2014 onwards

    Not from my barge pole, I wouldnt even use yours, Trevor, let alone mine

  86. #286
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    What we have here is an attitudenal chism

  87. #287
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    Is that similar to a schit attitude?

  88. #288
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    Yes - if the "c" is silent like P in PSmith

  89. #289
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by xladept View Post
    Yes - if the "c" is silent like P in PSmith
    A silent p, like in swimming pool?

  90. #290
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    No, Olly, I mean the one without a big grin

  91. #291
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2014 onwards

    Here is a well defined problem it seems and rather interesting. Surely there are lots of people here that can handle this? I can't/don't have time/bitten of more than I can chew etc.

    http://www.excelforum.com/excel-form...-criteria.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  92. #292
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by Jacc View Post
    Here is a well defined problem it seems and rather interesting. Surely there are lots of people here that can handle this? I can't/don't have time/bitten of more than I can chew etc.

    http://www.excelforum.com/excel-form...-criteria.html

    Jacc I had a look at this and posted a solution of sorts but some of the experts may be able to refine my solution. Probably easier to do in VBA but I've crafted something that will work with formulas only.
    Happy with my advice? Click on the * reputation button below

  93. #293
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    This OP has some EVENT code I've given for workbook_open and workbook_aftersave... they are looking to make that work from the Personal.xlsb file so they trigger on every workbook open and every workbook save event. I believe this will require some CLASS module assistance I've no real experience with yet.

    http://www.excelforum.com/excel-prog...e-changes.html

  94. #294
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    This is a FABULOUS question, I have been poking at it unsuccessfully for an hour now.

    http://www.excelforum.com/excel-form...e-formula.html


    Doing this in VBA would be trivially simple. But the formula approach has be baffled. Maybe not doable at all.

    =Randbetween(1,6)+Randbetween(1,6)
    ...is an easy way to simulate the total of 2 dice being rolled.

    This OP want to put a number in a cell that represents the number of "rolls" and have a single cell formula that does that many rolls on the fly. This is not same single roll multiplied 3 or 20 times, it should be 3 or 20 individual rolls of the two dice, and the random results added up. The key cell can be changed to any number of "rolls" and the random roll summarizer does that many rolls in the one cell.

    I'm baffled. Remember, I can knock out the VBA version, I'm looking for some brain power to help me ascertain, is it NOT doable by formulas only?

  95. #295
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Call in the Cavalry - 2014 onwards

    jBeaucaire I've put one solution up but you might want to test it.

  96. #296
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Yeah, a brute force formula, . No way to do 100 rolls there...but thanks for input.

  97. #297
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    @ Jerry - formulas are not my thing, but aren't there array formulas that could be constructed to do n rolls??

  98. #298
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by xladept View Post
    @ Jerry - formulas are not my thing, but aren't there array formulas that could be constructed to do n rolls??
    You'd think so wouldn't you?

    ....but it isn't quite that simple - e.g. if you use this formula

    =SUM(IF(ROW(A1:A100)<=B3,RANDBETWEEN(1,6)))

    You'd think that might generate and sum the correct amount of random numbers, but if B3 is 20 that just generates the same random number 20 times. I don't think you can use a single formula without helper cells (barring the "brute force" approach), unless you turn on iteration as suggested by MrShorty.
    Audere est facere

  99. #299
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by JBeaucaire View Post
    Yeah, a brute force formula, . No way to do 100 rolls there...but thanks for input.
    No 100 wouldn't work. OP asked for 20 and this does 21 actually but to do 100 then you could do this formula in 5 cells and add them which would give the same result.

    But ..... If I was doing 100 I think I'd tackle this differently (other than the obvious vba solution) and try to fit a curve to the distribution curve for the roll options between 100 and 600 noting that they have different probabilities. I worked a curve out for three dice rolls but that only has 216 combinations between 3 and 18. 100 rolls has 6^ 100 which is beyond my comprehension. I'd be UDFing this one.

  100. #300
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by Crooza View Post
    I'd be UDFing this one.
    Me too. The UDF would be remarkably simple. But I was thoroughly intrigued if a single formula could be created to do it.

  101. #301
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2014 onwards

    @ DDL -
    =SUM(IF(ROW(A1:A100)<=B3,RANDBETWEEN(1,6)))
    - you're saying that this only invokes the Rand() once??

  102. #302
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Romperstomper has slain this dragon. I am so thrilled, something new accomplished today. *sigh*

  103. #303
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Call in the Cavalry - 2014 onwards

    It's 1am and I've had a few, so in a good mindset.

  104. #304
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by xladept View Post
    @ DDL - - you're saying that this only invokes the Rand() once??
    Yes, you'll get an array of values but the "random" values will all be the same with the formula I suggested

    ......but I see a better way! Nice work Rory!
    Last edited by daddylonglegs; 10-22-2014 at 09:01 AM.

  105. #305
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Call in the Cavalry - 2014 onwards

    Ok, I've been toying around with this for a few days and I'm thoroughly stuck.

    https://www.excelforum.com/showthread.php?t=1043548

    OP has a number of rows by Account, and wants to sequentially deduct a given balance from each until a line zeroes out. This is either actually a hard question, or something deceptively simple.

  106. #306
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    Any thoughts on this one?

  107. #307
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    Any thoughts about why the Status bar is not showing the Count,Sum,Average,Numerical Count in the excel status bar eventhough everything is enabled in Customize Status Bar Popup Menu


    http://www.excelforum.com/excel-gene...ml#post3879494

  108. #308
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Call in the Cavalry - 2014 onwards

    If posting code please use code tags, see here.

  109. #309
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    This one has me completely stumped.... how to add .CSV permanently to the list of "All Excel Files" extensions that are offered when you activate the OPEN FILE window from inside EXCEL. Currently it lists all the .xls? options only.

    http://screencast.com/t/XHhZ7dnMk

  110. #310
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2014 onwards

    any one fancy a bit of vba tutoring?
    http://www.excelforum.com/excel-prog...p-problem.html

  111. #311
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    I tried to help this OP but the OP is not understanding the way I am trying to populate the data. I felt frustrated and not interested to go further, but I hope someone will take care of this post VBA question.

    http://www.excelforum.com/excel-prog...ml#post3882114

  112. #312
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    This is going to be a Sumif() function solution but I lost my patience here and I am not interested to give solution. Anyone please take care....

    http://www.excelforum.com/excel-prog...alues-vba.html

  113. #313
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    Anybody care to take a look at this: Fire up Worksheet_Change

    Regards, TMS

  114. #314
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2014 onwards

    I got most of what the OP wanted, but this thread has carried on for so long now that I am lost lol. They keep using different files (I think), Its aboyt different teams and players, and now they want a list of all players from teams selected. Im lost lol

    http://www.excelforum.com/excel-form...riteria-2.html

  115. #315
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2014 onwards

    I am officially in way over my head on this one. The OP marked thread [SOLVED]..........pre-maturely I'm sure.

    Post #14 summarizes my concerns. If nothing else I am in serious need of leadership and guidance on this one.

    http://www.excelforum.com/excel-gene...ttern-end.html

    Thanks,
    Dave

    Edit: [SOLVED]. 01:34 AM 11/4/2014
    Last edited by FlameRetired; 11-04-2014 at 03:35 AM.

  116. #316
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Call in the Cavalry - 2014 onwards

    anyone can help this person? I at least helped the OP to define his problem more.
    http://www.excelforum.com/excel-gene...t-hlookup.html
    thx. Sam
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  117. #317
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2014 onwards

    Anybody want to jump in onthis 1?

    http://www.excelforum.com/excel-prog...ml#post3893548

  118. #318
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2014 onwards

    I have another 1 here that could use some help...
    http://www.excelforum.com/excel-form...ml#post3894037

  119. #319
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2014 onwards

    Please, can someone look at this Thread and test the Code in the attachment to post 24?

    Make an entry into C12, entire Row 13 should unhide as it does on my platform...on the OP's it does not.

    Thanks, I appreciate.

    http://www.excelforum.com/excel-prog...hide-rows.html

  120. #320
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    @jaslake: something very strange is going on with this workbook/worksheet/code. I have put a Stop in at the top of the Worksheet_Change event handler. If I make a change in column A, it Stops, as expected. If I make a change in column C, it does not Stop. It does, however, convert a lower case x to an upper case X ... but it doesn't hide the rows.

    I'm guessing it has something to do with the UDF HasCmt which is applied to all the range of interest. CF formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    applied to
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Please Login or Register  to view this content.

    I note that when the UDF is commented out, my Stop is complied with. With the Stop working, you can step through the code. What is happening is that the first bit of code converts the content of the cell to Upper Case but the second Undo causes an error and goes directly to the Reset: label without executing the Unhide Row code. So, if you switch off the error trap you get Run-time error '1004': Method 'Undo' of object '_Application' failed.

    That's the problem. What to do about it ... over to you. Maybe you can't have an undo stack in VBA because VBA routines clear the undo stack.

    Regards, TMS

  121. #321
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2014 onwards

    @Trevor

    I appreciate you looking at this. I'm not certain what's going on but I'll remove the error handling and see where it leads.

    I'll get back to you and the OP...probably not tonight...I truly do appreciate the feedback.

    Thank you.

  122. #322
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    The OP on this thread has asked for second opinions:
    http://www.excelforum.com/excel-prog...ingle-row.html

  123. #323
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2014 onwards

    This is an Access Question: The OP has a table that he allows users to make changes to. I have advised him that this is a bad practice. I have also advised that no data should be removed from databases, but rather add a field to make a record inactive is the preferred db practice. The issue that the OP has, can code be written that is driven by changes to the table, similar to Worksheet_Change event in Excel. I am not aware of any VBA triggers from changes to Tables.

    If you can help, please look at this link.

    http://www.excelforum.com/access-tab...ess-table.html

  124. #324
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Conundrum


  125. #325
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Call in the Cavalry - 2014 onwards

    OP is trying to clean up a long formula, which is sort of a SUMPRODCT/COUNTIF but with multiple strings as criteria.

    Is it possible to use named ranges (of multiple cells) for criteria in a COUNTIF?

    https://www.excelforum.com/showthread.php?t=1051788

  126. #326
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    This OP appears to be asking a simple Conditional Formatting question that I truly am not grasping... too much turkey in my system perhaps.
    http://www.excelforum.com/excel-gene...ergen-map.html

    Can anyone see the simple thing I am missing?

  127. #327
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    OP wants to bypass the Alert Message in IE 11

    I don't know anything about HTML object and all, so anyone please take care of this thread

    http://www.excelforum.com/excel-prog...ml#post3916115

  128. #328
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Call in the Cavalry - 2014 onwards

    OP wants to paste clipboard to ActiveCell, inserting rows to make room for however many cells are in clipboard.

    Can't figure out a way to stop Excel from copying clipboard into every new cell in the inserted rows.

    https://www.excelforum.com/showthread.php?t=1052424

  129. #329
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Call in the Cavalry - 2014 onwards

    Anyone want to have a go at this?

    http://www.excelforum.com/excel-gene...formula-2.html

    I don't have the time at the moment to look into this one, and it's certainly not a case for a single-cell solution, I would imagine.

    Thanks a lot

  130. #330
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2014 onwards

    I can't wrap my head around what he's asking for or doing here.

    http://www.excelforum.com/excel-form...med-range.html

  131. #331
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Call in the Cavalry - 2014 onwards

    I am totally stumpped.. Can anyone help me.. to solve..

    http://www.excelforum.com/excel-form...hree-rows.html
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  132. #332
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards


  133. #333
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2014 onwards

    I'm out of ideas on this issue. If you are up to it--->http://www.excelforum.com/excel-prog...not-empty.html

  134. #334
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2014 onwards

    Can anyone help here please?
    http://www.excelforum.com/excel-gene...ml#post3928510

    I have no idea what they want

  135. #335
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by FDibbins View Post
    Can anyone help here please?
    http://www.excelforum.com/excel-gene...ml#post3928510

    I have no idea what they want
    Made an attempt

    I am rather drunk. It may not make much sense

  136. #336
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by Olly View Post
    Made an attempt

    I am rather drunk. It may not make much sense
    Not sure if it's because I am drunk or despite it, but I reckon that's a pretty cool solution

  137. #337
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2014 onwards

    Not sure what I am missing... the date selection in Autofilter is not picking the actual date (VBA)

    http://www.excelforum.com/excel-gene...ate-range.html

  138. #338
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards

    Can anybody find a formula approach to this?
    http://www.excelforum.com/excel-form...ncatenate.html

  139. #339
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards


  140. #340
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Call in the Cavalry - 2014 onwards


  141. #341
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards


  142. #342
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Call in the Cavalry - 2014 onwards

    Can someone have a look at this, please. Lost on me.

    http://www.excelforum.com/excel-prog...rten-data.html

    Regards, TMS

  143. #343
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards


  144. #344
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Call in the Cavalry - 2014 onwards

    I guess I'm too tired to understand this today.. So can someone jump in: http://www.excelforum.com/excel-prog...-two-rows.html

  145. #345
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2014 onwards

    ive gone as far as i can with this chart problem any takers
    http://www.excelforum.com/excel-char...-the-week.html

  146. #346
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2014 onwards

    This thread has suddenly entered an arena I know nothing about: http://www.excelforum.com/excel-char...curve-fit.html The OP indicates that he wants to be able to add an option to the chart trendline dialog to accomplish his task rather than do the work directly in the spreadsheet. Anyone who wants to dive into this one? Is it even possible to modify Excel's built-in dialogs?

  147. #347
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards

    Can't seem to get Vlookup up to work in the Userforms
    http://www.excelforum.com/excel-prog...ml#post3944556

  148. #348
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Call in the Cavalry - 2014 onwards

    Isn't its time to create a new thread..

    "Call in the Cavalry - 2015 onwards "

  149. #349
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by Debraj Roy View Post
    Isn't its time to create a new thread..

    "Call in the Cavalry - 2015 onwards "
    Hre it is,
    http://www.excelforum.com/the-water-...ml#post3944935

  150. #350
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Call in the Cavalry - 2014 onwards

    ...pedantic note. 2015 is '2014 onwards'

    I'll get me coat...
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  151. #351
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2014 onwards

    Oh ya, Ha!

  152. #352
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2014 onwards

    All who are interested should perhaps subscribe to the 2015 Cavalry thread started here:
    http://www.excelforum.com/the-water-...5-onwards.html

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Call in the Cavalry - 2015
    By davesexcel in forum The Water Cooler
    Replies: 297
    Last Post: 01-13-2016, 06:50 PM
  2. [SOLVED] Call in the cavalry -- need help solving this thread-prior to 2013
    By teylyn in forum The Water Cooler
    Replies: 821
    Last Post: 01-06-2015, 08:01 PM
  3. Call in the Cavalry - 2013
    By FDibbins in forum The Water Cooler
    Replies: 457
    Last Post: 01-06-2015, 08:00 PM
  4. Call in the Cavalry too long now so teach me something...
    By MarvinP in forum The Water Cooler
    Replies: 0
    Last Post: 12-26-2014, 04:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1