Closed Thread
Results 1 to 148 of 148

Call in the Cavalry - 2016

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

    Call in the Cavalry - 2016

    2016 - Happy New Year.
    http://www.excelforum.com/the-water-...ry-2015-a.html
    _________________
    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!)

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    Quote Originally Posted by JBeaucaire View Post
    Let's hope so. But I do wonder whether your post should be allowed as it contains a circular reference


    click on the * Add Reputation if this was useful or entertaining.

  3. #3
    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 - 2016

    Maybe someone can help this guy http://www.excelforum.com/excel-gene...worksheet.html I tried after need overman gave up but also failed.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    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 - 2016

    meus,
    this is not thread for asking help to promote your own questions.
    Therefore it will be deleted.

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

    Re: Call in the Cavalry - 2016

    Need some VBA help here. I couldn't get it to work because of merged cells

    http://www.excelforum.com/excel-form...down-list.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

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

    Re: Call in the Cavalry - 2016

    Okay, this one is weird. I am curious as to the solution. Ghost dropdown boxes.

    http://www.excelforum.com/excel-form...w-appears.html

  7. #7
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    Quote Originally Posted by ChemistB View Post
    Okay, this one is weird. I am curious as to the solution. Ghost dropdown boxes.

    http://www.excelforum.com/excel-form...w-appears.html
    Interesting

  8. #8
    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 - 2016

    I doubt this is do-able, but putting it outh there for others to have a go at...
    http://www.excelforum.com/excel-new-...-question.html
    data is VERY messy
    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

  9. #9
    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 - 2016

    @Ford

    For me the Link is broken..............
    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.

  10. #10
    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 - 2016


  11. #11
    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 - 2016

    This one seems to be headed from Excel into web programming. http://www.excelforum.com/excel-gene...g-a-graph.html

    Recognizing that this is the kind of thing that one might hire a web development company to do, is there anyone experienced with integrating Excel and web based things that would like to contribute their expertise?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  12. #12
    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 - 2016

    Hi All,

    "We have us a failure to communicate" - hopefully, someone will be able to help this OP
    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

  13. #13
    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 - 2016

    Have a thread here, cannot replicate the OP's prolem. Anyone else what to have a go?
    http://www.excelforum.com/excel-form...ml#post4291546

    edit: OK this appears to be solved. OP had links to sites that were not working...seems they had blocked excel from accessing the web
    Last edited by FDibbins; 01-17-2016 at 11:08 PM.

  14. #14
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Call in the Cavalry - 2016

    Excel to Outlook (not the best code to do this I assume) and user wants a border around the mail which is put together in Excel VBA as HTML: Help request to add a colored border to the message. Please mind that due to Sucuri you can´t post the code either in the Forum nor in a PM, you would have to attach a workbook or send a copy to user.

    Maybe Ron de Bruin´s RangeToHTML could be modified to work but according to his HP it´s cutting out all Pictures. I´m out of time (and out of ideas).

    Thanks for reading and thinking about any solution / alternative in advance.

    Holger

  15. #15
    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,086

    Re: Call in the Cavalry - 2016

    Anyone take a look at this one? I don't have Excel 2003 on any of my machines now.

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

    Thanks
    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


  16. #16
    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 - 2016

    I fear that I am misleading this OP ... before I do more damage will someone have a look at this thread? It appears to require a statistician.

    http://www.excelforum.com/excel-form...rformance.html
    Dave

  17. #17
    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 - 2016

    if I'm understanding what this person wants, it is a vlookup that doesn't update previous information (?) when he / she enters new reference data. Maybe a VBA solution would work (though I'm not sure) or other (non VBA) ideas I didn't think of.
    http://www.excelforum.com/excel-form...h-vlookup.html

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

    Re: Call in the Cavalry - 2016

    Can't figure out a good way to do this one.

    http://www.excelforum.com/excel-form...r-to-year.html

  19. #19
    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 - 2016

    SaveAs PDF VBA code is throwing error to this OP. Tried a lot in all combinations but unable to fix the issue.

    Anyone please advice.

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


    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

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

    Re: Call in the Cavalry - 2016


  21. #21
    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 - 2016

    Anybody see this before?

    Same HyperLink using Word and Excel producing different results.

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

  22. #22
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    I am guessing with this one.
    As I understand it : using the menu button to link to an access data source is not bringing up the dialog box.
    http://www.excelforum.com/excel-gene...ssue-help.html

  23. #23
    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 - 2016


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

    Pivot Tables

    I'm going to resort to a formula answer here because I don't think the OP can get the visual result they want with pivot tables. I even tried 2 tables with the second one's headers hidden but the columns didn't line up. However, I know there are some Pivot Table Wizards out there if you want to give it a go.

    http://www.excelforum.com/excel-char...me-period.html

  25. #25
    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 - 2016

    I have gotten in over my head with this one. OP has multiple same-named ranges across multiple sheets. They have uploaded a sample WB. I don't even know what questions to ask.

    Anyone?

    http://www.excelforum.com/excel-gene...ml#post4315924
    Last edited by FlameRetired; 02-12-2016 at 07:07 PM.

  26. #26
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Call in the Cavalry - 2016

    Hi,

    Who is good with Folders and SubFolders. I'm headed to bed and hate to leave this guy dangling. Looping through folders isn't my expertise.

    http://www.excelforum.com/excel-prog...ubfolders.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  27. #27
    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 - 2016

    This is weird. VLOOKUP and MATCH work, but SUMIFS doesn't with the same criteria.

    http://www.excelforum.com/showthread...76#post4320676

    Edit Disregard. Solved it. I've never used this particular syntax of criteria before. SUMIFS is referencing a cell that contains the text "< 21". Apparently it evaluates that literally.
    Last edited by FlameRetired; 02-17-2016 at 11:57 PM.

  28. #28
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Call in the Cavalry - 2016

    Hello and warm regards
    can anyone help OP, I tried but may be I am missing something
    http://www.excelforum.com/showthread...t=#post4321828
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  29. #29
    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 - 2016

    Anyone want to take a look at this please? OP has some mixed up data they need to fic...
    http://www.excelforum.com/excel-gene...ed-to-fix.html

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

    Re: Call in the Cavalry - 2016

    Hi Ford,

    I've responded with a formula solution.

    Pete

  31. #31
    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 - 2016

    Thanks pete

  32. #32
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    Am I right in thinking there isn't , USING WOKSHEET FUNCTIONS, a means of ... returning a range being a filtered set of cells from a table. The values being in column A and the criteria in columns B & C

    Easy enough in VBA.

    trimmean-function-with-multiple-if-criteria.html

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

    Re: Call in the Cavalry - 2016

    Data reorganization, probably best done with VBA

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

  34. #34
    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 - 2016

    Hey Good People

    This is RE: http://www.excelforum.com/excel-gene...obox-help.html

    File is attached to Post #14.

    I've tested the Code in Excel 2007 and 2010 and it performs as expected. The OP is using Excel 2013...I don't have Excel 2013. We've looked at Settings and all appears to be in order.

    The OP is not getting the Drop Down Combo Box Data in Column K on the OP's platform (as I am on my platform in 2007 and 2010). Anybody have a clue why?

    Appreciate your input
    Last edited by jaslake; 03-13-2016 at 02:05 AM.

  35. #35
    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 - 2016

    Hi John,

    Your solution works on my system, which is 2010.

    Orrin

  36. #36
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    in 2013 I am missing the list as well (in that it appears to be an empty list in the drop down).
    I'll have a bit of a look.

    Just checked in 2007 and the list is there.
    Last edited by tony h; 03-13-2016 at 02:35 PM.

  37. #37
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    I have posted a new one on the original thread

    I don't know whether I have lost some of the associated VBA functionality.


    I was getting occasional errors in the selection change event as it errored in the use of the object set to activesheet and sheets("Max Zs... activesheet was an "Object not set" and the other failed similarly.

    Changing to thisworkbook.sheets(... worked and using the actual thisworkbook.sheets(1) was ok.

    The dropdowns is odd. Going to the Data Validation options for the cells didn't show the validation options at all.

    I de merged the cells, cleared out the validation, reset the validation (List and Type) then reset the merge.

    I then tested it the drop down and reopened in 2007 that seemed ok as well,

    But, I haven't checked whether I have inadvertently mucked up any of the VBA (or other formulae as a result)

    I will have another look.
    Last edited by tony h; 03-13-2016 at 04:08 PM. Reason: additional information

  38. #38
    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 - 2016

    Thanks for the feedback Orrin.

  39. #39
    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 - 2016

    Thanks Tony

  40. #40
    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 - 2016

    It looks like the "dynamic requirements" mandate a different approach here - hope someone can help this OP:|

  41. #41
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2016

    Surface Pro 4 odd behaviour. Excel 2013.

    I solved the original problem that Jaslake raised. But now there is a difference when running on a Surface Pro.

    The solution uses a dropdown list which is dynamically positioned to look similar to a data-validation list. The user reports the worksheet is performing correctly except when running on a Surface pro. In this situation focus won't leave the dropdown list

    http://www.excelforum.com/excel-gene...obox-help.html

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

    Re: Call in the Cavalry - 2016

    I'm beginning to believe, this will need a VBA solution.

    http://www.excelforum.com/excel-form...-in-table.html
    Thanks

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

    Re: Call in the Cavalry - 2016


  44. #44
    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 - 2016

    Can anyone lend a hand on this one...

    Count unique entries.

    It should be simple but there are multiple files involved and I have an aversion to downloading files!

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

    EDIT: Never mind. I think we got it under control!
    Last edited by Tony Valko; 03-18-2016 at 01:30 PM.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  45. #45
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Call in the Cavalry - 2016

    OP wants to allocate actual costs (not average) against sales
    Could do it single sku level with running total cant envisage how it can be done at multiple sku level

    It's not something i would be doing normally in Excel nor is it a accounting model i have used previously (in Excel..i usually use average COGS)

    anyone else here come across a viable solution?
    http://www.excelforum.com/excel-form...re-simple.html
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  46. #46
    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 - 2016

    I'm not sure if this can even be done...

    OP has a simple sum formula that references multiple ranges.

    =SUM(Range1,Range2,Range3,Range4)

    Wants to delete some rows that encompass Range3 and Range4 and when they do this the formula "breaks" with a #REF! error.

    I suggested using INDIRECT but they say that won't work because the formula ranges are still "live" after the rows are deleted.



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

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

    Re: Call in the Cavalry - 2016

    Quote Originally Posted by Tony Valko View Post
    ...I'm not sure if this can even be done...
    Hi Tony,

    I've not had any feedback about my proposed solution, but it seems to work for me.

    Pete

  48. #48
    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 - 2016

    The OP has said the formula needs to be "dynamic" after the row deletions.

    Not sure what that means.

  49. #49
    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,086

    Re: Call in the Cavalry - 2016

    Anyone with 2013+ want to check this out: http://www.excelforum.com/excel-form...ng-issues.html

    I can't reproduce the effect in 2007.

  50. #50
    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 - 2016

    This one, IMO, has gone beyond Excel programming and into the more generic algorithm development stage: http://www.excelforum.com/excel-prog...te-values.html
    In my post, I guess I seem pessimistic that we have someone here who would be able (and/or willing) to develop a more efficient algorithm than the brute force algorithm I suggested. If anyone wants to look at it... Someone may recognize the problem as a common problem and already be familiar with more efficient algorithms. I admit that I don't understand the problem well enough (and have not taken the time to understand the problem well enough) to see echoes of common problems in this specific application.

  51. #51
    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,086

    Re: Call in the Cavalry - 2016

    Anyone care to have a look at this: http://www.excelforum.com/excel-prog...-to-excel.html

    I have clarified what the formula actually is and, hence, which cells it refers to. I've then tried putting the Array Formula in in A1 format rather than R1C1 but it still won't play.

    Would appreciate any thoughts, ideas or alternatives.

  52. #52
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Call in the Cavalry - 2016

    OP is looking for UDF to looking at extract range of terms and range of cells
    http://www.excelforum.com/excel-form...fied-text.html

    was thinking dictionaries or REGEXP would be the answer but a bit outside my range of knowledge

    Edit: i put a Frankenstein solution together which may work for OP
    Last edited by humdingaling; 04-18-2016 at 10:44 PM.

  53. #53
    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 - 2016

    This one is likely to go places that I am not very good at: http://www.excelforum.com/excel-prog...xcel-file.html

    The easiest solution that I see is to get Crystal Reports to output the data directly to Excel, or to a file format that Excel can more easily read. If someone is familiar with CR (especially its online version), that might be the most helpful.
    Rich text format just has so much unnecessary garbage embedded in it, that it looks difficult to get Excel to extract the real information from the other stuff.
    converting rich text to basic text puts all of the data into a single column. I'm sure it is possible to take the data in a single column and rearrange it into a table (OP has not explained what the final output should look like), but that seems like a lot of work, when it seems like Crystal Reports should be able to generate the report in a format that the OP can easily read into Excel.

  54. #54
    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 - 2016

    Any of you good people that have Excel 2016 like to take a look at this?

    The OP Has Emails being sent on Workbook Open (Reference to Outlook required).

    The Code performs as expected in Excel 2007 and 2010. The OP has Excel 2016. If the OP changes from Send to Display the Outlook Email displays. If the OP changes Display to Send nothing appears to happen (no email is sent).

    http://www.excelforum.com/showthread...=1#post4371141

  55. #55
    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 - 2016

    http://www.excelforum.com/excel-char...ar-charts.html

    I knew enough to recommend a pivot table/chart, but, the OP needs a little more help than I can provide.

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

    Re: Call in the Cavalry - 2016


  57. #57
    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,086

    Re: Call in the Cavalry - 2016

    Can someone look at this please.

    http://www.excelforum.com/excel-gene...iling-out.html

    Should be very straightforward. The OP was attaching an Excel file to an email and wants to protect it. I suggested using a .pdf file instead. So, instead of copying the active sheet to a new workbook, saving it to a temporary location, attaching it to the email and then deleting the temporary file, I'm suggesting just export the active sheet as a .pdf, attach that, and then delete it. Same principle. But struggling to communicate. I'm on holiday with no computer so can't easily modify and test the code. (5 minute job if I could )

  58. #58
    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 - 2016

    OP is asking if you can "live update" between two open files across a network. Not sure that you can?
    http://www.excelforum.com/excel-gene...-from-1-a.html

  59. #59
    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 - 2016

    Can someone take a look at this...

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

    It's about calculating the time difference.

    It sounds very simple but the sample file contains VBA and I won't download files with VBA.

  60. #60
    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 - 2016

    Can someone look this strange behavior on extrapolation:

    http://www.excelforum.com/showthread...=1#post4384884

    In this post you have data.
    And trendline is created from blue dots.

    If you copy that formula (you have it in post #6) and create new line you will get red interpolation.
    With same trendline.
    But obviously very different output.

  61. #61
    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 - 2016

    Member needs some assistance with some VBA code...
    http://www.excelforum.com/showthread...t=#post4387519

  62. #62
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2016

    Not sure I have a solution here...any takers
    http://www.excelforum.com/excel-form...condition.html
    HTH
    Regards, Jeff

  63. #63
    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 - 2016

    This one is beyond the kind of database management I do. http://www.excelforum.com/showthread...87#post4390987
    I can kind of see how to do it, and I'm sure I could put the entire procedure together, if I wanted to take the time to test and debug something. I expect that one of you who is more proficient in database management may have a procedure written or are aware of preprogrammed utilities for this sort of thing.

  64. #64
    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 - 2016

    We may have identified a problem in this thread: http://www.excelforum.com/showthread...=1#post4398745 The issue might be with the OP's version of Excel (2016) converting text to date where my version (2007) does not. Can anyone take a look (maybe someone with 2016) to see if 2016 behaves differently from 2007 in this respect?

  65. #65
    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 - 2016

    Being a late adopter, I am still using 2007. I don't know where the "multi-level category axis" checkbox is in the 2013 dialogs. Can someone who knows their way around 2013 give some help locating this checkbox?
    http://www.excelforum.com/showthread...59#post4402159

  66. #66
    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 - 2016

    Another one that might be related to differences in Excel 2016: http://www.excelforum.com/showthread...=1#post4402434 that I cannot test.

  67. #67
    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 - 2016

    I'm stumped. Cannot come up with formula to calculate these.


    http://www.excelforum.com/showthread...43#post4405043

  68. #68
    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 - 2016

    Anyone care to take a look at this thread?
    http://www.excelforum.com/showthread...73#post4407073
    OP claims "Excel breaks Alt+Tab function of windows 8.1"

  69. #69
    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 - 2016

    Anybody have any insight on this?

    Have I missed something?
    If posting code please use code tags, see here.

  70. #70
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Call in the Cavalry - 2016

    Could anyone who uses Acess tell me why it doesn't like my SQL on this thread please? http://www.excelforum.com/showthread...70#post4414970

  71. #71
    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 - 2016

    Interesting question...
    =TEXT(ROW(C1),"C - 000")
    works but
    =TEXT(ROW(C1),"D - 000")
    does not.

    why??

    http://www.excelforum.com/excel-form...ula-error.html

  72. #72
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2016

    But =TEXT(1;"\D - 000") does.

    Remember "d " is being interpreted as date.



  73. #73
    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 - 2016

    I think I am about to do more harm than good here. Cannot seem to follow the logic of this one. I think it's me and not them.

    http://www.excelforum.com/showthread...67#post4419667

  74. #74
    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 - 2016

    Time for some fresh input on this issue. Out of my wheel house. Putty? API?

    http://www.excelforum.com/excel-prog...indows-up.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

  75. #75
    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 - 2016

    Quote Originally Posted by snb View Post
    But =TEXT(1;"\D - 000") does.

    Remember "d " is being interpreted as date.
    Yup, as soon as you said that, the light went on - serious duh moment

  76. #76
    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 - 2016

    This one started off simple enough ... I am lost and confused.
    http://www.excelforum.com/showthread...89#post4420689

  77. #77
    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 - 2016

    I believe there are better ways to accomplish what the OP wants here than either of us is familiar with: http://www.excelforum.com/showthread...=1#post4422855 With my skill level, I would use arrays to do it. The part that seems to be the heart of the question is how to use a text string as the array index (and I showed how I would do that). It seems like there might be other ways to use a text string like an array index, and I invite more experienced and knowledgeable programmers to offer their suggestions.

  78. #78
    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 - 2016

    Here is a PasteSpecial type request that I cannot provide the OP with an answer.
    http://www.excelforum.com/excel-gene...en-sheets.html

  79. #79
    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 - 2016

    The original question http://www.excelforum.com/showthread...54#post4428254 looked like it would be about nesting a udf inside of a built in function, which I have quite a bit of experience with. Upon further enlightenment, the problem seems more related to getting information from a userform, and I have no experience with userforms. Anyone pitch in and help?

  80. #80
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Office 265 and Custom Formats

    Can anyone with Office 365 experience look in on http://www.excelforum.com/excel-form...m-format.html?

    Specifically, in Office 365, do custom formats belong to the application, versus to workbooks, as in all prior versions up to at least Excel 2010?
    Entia non sunt multiplicanda sine necessitate

  81. #81
    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 - 2016

    Looks like an enormously complex string parsing. Perhaps I am not seeing some usable pattern(s). I am out of ideas.


    http://www.excelforum.com/excel-form...t-problem.html

  82. #82
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Call in the Cavalry - 2016

    http://www.excelforum.com/excel-prog...-one-page.html
    OP doesnt want to use fit to page ...even though the output is the same in my experiments
    but rather wants to set pagesetup.zoom but integer at time

    the code provided didnt want to update page numbers and the code i provided afterwards seems to work if you run the code line by line (holding down F8)....however just run without breaks ....it doesnt seem to work for me (ie page number does not move)

    anyone else experience this or have work around

  83. #83
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Call in the Cavalry - 2016

    Please could any of you brilliant fellow members assist me with this thread: http://www.excelforum.com/excel-prog...hanges-2.html

    Everything I have suggested thus far does not seem to be good enough and, I just can't seem to find a way to tweak or add to his current subject, without redoing the whole project, for which I do not have the time, or inclination for.

    I also don't understand why he wants it the way he explains, as for as far as I am concerned, I don't see the need for that.

    Thank you guys.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  84. #84
    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,086

    Re: Call in the Cavalry - 2016

    Anyone care to look at this: http://www.excelforum.com/excel-prog...ge-failed.html

    The code does work in its own right. However, an error occurs in the live workbook with 20+ linked worksheets.

    Thanks

  85. #85
    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,086

    Re: Call in the Cavalry - 2016

    @Winon: the link doesn't work.

  86. #86
    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 - 2016

    Quote Originally Posted by TMS View Post
    @Winon: the link doesn't work.
    worked for me

  87. #87
    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,086

    Re: Call in the Cavalry - 2016

    @Ford: you calling me a liar? I get a 404 Page not Found

  88. #88
    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 - 2016

    @Winon
    The Link is also broken for me (404 error)...

  89. #89
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Call in the Cavalry - 2016


  90. #90
    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,086

    Re: Call in the Cavalry - 2016

    This link is the one that's broken: http://www.excelforum.com/excel-prog...hanges-2.html

  91. #91
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Call in the Cavalry - 2016

    Ah -- that one is truly broken.

  92. #92
    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 - 2016

    @TMS


    Same issue...
    Broken Link.jpg

  93. #93
    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,086

    Re: Call in the Cavalry - 2016

    @jaslake: yes, that's the very one. Glad it's not just me

  94. #94
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Call in the Cavalry - 2016

    Thanks Guys, much appreciated, really!

    FDibbins became known to me as a man always with a trick up is sleeve somewhere.

    @ TMS and jaslake,

    Hopefully this link will guide you. http://www.excelforum.com/showthread...6316&p=4425875

    Thank you for "Both of you three" looking at it, at least. Much appreciated!!!

    Kind greetings.

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

    Re: Office 265 and Custom Formats

    Has anybody worked with this before?

    OP has many "or" & "and" in a single string and would like to be able to color them.


    http://www.excelforum.com/excel-prog...ng-ranges.html

  96. #96
    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 - 2016

    Quote Originally Posted by TMS View Post
    @Ford: you calling me a liar? I get a 404 Page not Found
    Not for an instant Just saying that I could open the link, and it took me here...
    http://www.excelforum.com/excel-prog...ge-failed.html

  97. #97
    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,086

    Re: Call in the Cavalry - 2016

    You're referring to MY link which does work.

    This is the broken one from Winon:
    Please could any of you brilliant fellow members assist me with this thread: http://www.excelforum.com/excel-prog...hanges-2.html

  98. #98
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Call in the Cavalry - 2016

    Anyone know exactly what he's after?

    http://www.excelforum.com/excel-form...i-formula.html
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  99. #99
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2016

    I thought I was going to be able to come up with something here, but alas, I have failed.

    Could somebody please lend a hand?

    http://www.excelforum.com/excel-form...-is-other.html

  100. #100
    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 - 2016

    Anybody have a handle on Google sheets?

    http://www.excelforum.com/showthread...96#post4437096

  101. #101
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2016


  102. #102
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Call in the Cavalry - 2016

    Is anyone able to finish this one off? It's to do with creating and sorting a list using an array formula.

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  103. #103
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Call in the Cavalry - 2016

    Hi all
    Any VBA experts able to suggest anything here:

    http://www.excelforum.com/showthread...8591&p=4438502

    The OP wants a time stamp on specific cells on a formula recalculation. As far as I know the Calculate Event has no Target method and the Change Event doesn't fire with formula changes. I tried Dependants but that only works on the Active sheet and the Dependants are on other sheets and workbooks.

    DBY

  104. #104
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Call in the Cavalry - 2016

    Is anyone able to finish this one off for me?

    http://www.excelforum.com/showthread...02#post4442802

  105. #105
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Call in the Cavalry - 2016

    Does anyone know why AVERAGE and AVERAGEIF give such different answers here?

    http://www.excelforum.com/excel-gene...rted-data.html

    Am I being really stupid? What am I missing? Is this another floating points issue???

    EDIT: Please ignore - major blonde moment!!!
    Last edited by AliGW; 08-01-2016 at 05:19 AM.

  106. #106
    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 - 2016

    One of these days I'll REALLY spend the time to figure out some chops for web scraping using HTML.

    http://www.excelforum.com/excel-prog...iqy-files.html

    This thread the user is trying to use Web Query for multiple URLs and it won't work, the table data is hidden. Anyone that can offer alternate methods, please have a look.
    Thanks.

  107. #107
    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 - 2016

    Any VBA experts want to take a look at this please?
    http://www.excelforum.com/excel-prog...ot-fields.html

  108. #108
    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 - 2016

    Conditional formatting request...

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

    Should be easy but I'm just not getting it!

  109. #109
    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 - 2016

    Two successive copy commands, my eye can't see what the problem is. Can you?
    http://www.excelforum.com/excel-prog...ork-right.html

  110. #110
    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 - 2016

    Another pivot table thread that quickly exceeded my skill and knowledge of pivot tables http://www.excelforum.com/showthread...=1#post4464661

    I can see the difference between the OP's source table, and the quick example that I put together, and I can see that this difference seems to drive the "Grand total" column in the PT. But I do not know (other than completely revamping the source table/database) how to get the Grand Total column to appear in the OP's PT.

  111. #111
    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 - 2016

    As a late adopter, I am sometimes behind in Excel versions. Some of that is fear of MS changing features that I like in the version(s) I currently use. This OP is having trouble copying/pasting formulas from one workbook to another -- something I do all the time and never have trouble with in my older versions. Can someone with 2010 or newer look at the OP's screenshot and comment on his/her available paste options? Why is a simple "paste" option not available? Or is it available and he/she is not understanding the options being offered by the context menu. http://www.excelforum.com/showthread...76#post4468976

  112. #112
    Forum Contributor
    Join Date
    08-23-2016
    Location
    India
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    194

    Re: Call in the Cavalry - 2016

    Ash

  113. #113
    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 - 2016

    This is the same thread Ash_Maverick posted above. We've been through multiple steps, and now in the next (final?) step it appears OP needs a change-something macros event. I can't help them there.

    http://www.excelforum.com/showthread...00#post4470500

  114. #114
    Forum Contributor
    Join Date
    08-23-2016
    Location
    India
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    194

    Re: Call in the Cavalry - 2016

    Need help with my own post please..........http://www.excelforum.com/showthread...41#post4471441

  115. #115
    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 - 2016

    OP is looking for something I cannot envision. http://www.excelforum.com/excel-prog...ng-scores.html

  116. #116
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Call in the Cavalry - 2016

    Trouble with date in VBA with Clng funtion in VBA. Does anybody have experience on this?

    http://www.excelforum.com/showthread...09#post4472509
    Quang PT

  117. #117
    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 - 2016

    A very interesting question, why a single line of code fails on only 1 of his 4 computers. Any one have a guess?
    http://www.excelforum.com/showthread.php?t=1154291

  118. #118
    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 - 2016

    This OP want counts of and listing of duplicates between 20 sheets ... some with over 14K rows. I can't do that with formulas. This looks like a VBA ... (with a NASA computer) ... problem.

    http://www.excelforum.com/showthread...87#post4472787

  119. #119
    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 - 2016

    I think I've 'blown' a neuron here.

    The last post puts additional condition on an awkward layout. Don't know how to solve or advise.

    http://www.excelforum.com/showthread...51#post4474451

  120. #120
    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 - 2016

    Another one.

    The first part is straight forward enough. I am not able to do anything with the follow-up. Not even sure it's doable.

    http://www.excelforum.com/showthread...70#post4475970

  121. #121
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2016

    @flame

    I would appreciate it if you were giving some feedback after having 'called in someone from the cavalry'.

  122. #122
    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 - 2016

    Quote Originally Posted by snb View Post
    @flame

    I would appreciate it if you were giving some feedback after having 'called in someone from the cavalry'.
    You are quite correct. My apologies, and thank for responding post #118.

  123. #123
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Call in the Cavalry - 2016

    I'm getting this when adding code to Post. Anyone know what is going on? I do notice if the code has a formula in the post then I'm getting the below reply.

    My code post are in between the code tags. See txt file, If I remove this peace of code from my post, my post will go thru. Very confused. Anyone else experience this issue?

    Sucuri WebSite Firewall - CloudProxy - Access Denied
    What is going on?
    You are not allowed to access the requested page. If you are the site owner, please open a ticket in our support page if you think it was caused by an error: https://support.sucuri.net. If you are not the owner of the web site, you can contact us at [email protected]. Also make sure to include the block details (displayed below), so we can better troubleshoot the error.
    Block details
    Your IP: 73.27.2.156
    URL: http://www.excelforum.com/newreply.p...eply&t=1119690
    Your Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14
    Block ID: BLKUNF1
    Block reason: Your request was not authorized due to its content (HTML code not allowed).
    Time: Sun, 11 Sep 2016 12:55:08 -0400
    Server ID: cp14015
    Sucuri CloudProxy
    CloudProxy is a WebSite Firewall from Sucuri. It stands between your site and the rest of the world and protects against attacks, malware infections, DDOS, brute force attempts and mostly anything that can harm it.
    Not only that, but your sites get cached, speeding it up quite a bit. Interested? Visit http://cloudproxy.sucuri.net
    Attached Files Attached Files
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  124. #124
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2016

    Hi Mike,
    Probably need to add a space after a < .. or similar ... or use the Black character trick

    it is a known problem that scurri does not like some combination of characters

    http://www.excelforum.com/showthread...41#post4412541
    http://www.excelforum.com/showthread...96#post4295096

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  125. #125
    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 - 2016

    Hi Mike,

    As Doc has indicated it's probably the Sumif so make it < Sumif and try

  126. #126
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Call in the Cavalry - 2016

    Thanks Allen and Orrin. I'll give that a try.

  127. #127
    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 - 2016

    You're welcome!

  128. #128
    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 - 2016

    This thread is heading down the "put Solver in a loop" road that I am not near as good as some of you at. I have pointed the OP to an example of code by Alf in another thread. If he/she needs more help, I expect some of you will be better able to help with the nuances of putting Solver in a loop than I will.

    http://www.excelforum.com/excel-form...tool-pack.html

  129. #129
    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 - 2016

    I have no idea what this OP is trying to do. Maybe one of you can understand his explanation.

    http://www.excelforum.com/excel-form...ank-cells.html

  130. #130
    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 - 2016

    This thread has gone into event code that I am going to be unfamiliar with. They want to override or prevent Excel from resizing a chart that overlays inserted or deleted rows/columns when they insert/delete rows/columns.

    http://www.excelforum.com/excel-prog...ate-graph.html

  131. #131
    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 - 2016

    Anyone know how to array enter a formula on a Mac?

    I did a Google search and found CMD-Return. Apparently that's not working for this person:

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

  132. #132
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Call in the Cavalry - 2016

    I am totally lost as to how approach the requirements of this OP.

    I think he wants to populate the next empty row of different Columns with varying lengths, with values from an External link, which I cannot access.

    Anyone care to take a look?

    http://www.excelforum.com/showthread...2&goto=newpost

    Thank you.
    Last edited by Winon; 09-30-2016 at 02:16 PM.

  133. #133
    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 - 2016

    Using the MacID("Text") thing for searching for files in a folder, doesn't seem to be working for this user. Any ideas?
    http://www.excelforum.com/showthread.php?t=1158143

  134. #134
    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 - 2016

    If you have one drive maybe you can help this guy.

  135. #135
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2016

    Hi Orrin
    Quote Originally Posted by xladept View Post
    If you have one drive maybe you can help this guy.
    which guy ?
    Alan

    EDIT : OK ignore this Post: The Forum Software was having another Paddy, and no Link was shown. I can see the Link to this guy now
    Last edited by Doc.AElstein; 10-07-2016 at 05:43 AM.

  136. #136
    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 - 2016

    This OP wants to apply headers to each page (conditionally) by page ranges. Ex. 1-4, 5-20 ...

    I can't find a way and I am not VBA proficient.

    Can this even be done?


    http://www.excelforum.com/showthread...32#post4505532

  137. #137
    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 - 2016

    This started out smoothly enough. OP now wants to do something more creative with drop downs. Even if I could understand I suspect this one is over my head.

    http://www.excelforum.com/showthread...90#post4508390

  138. #138
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Call in the Cavalry - 2016

    Can anyone understand what the OP is after here?

    http://www.excelforum.com/showthread...80#post4508580

    I am feeling mathematically challenged ...

  139. #139
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Call in the Cavalry - 2016

    Looks like this one requires a VBA solution: http://www.excelforum.com/showthread...13#post4509313

    I've advised the OP to change the thread title to reflect this.

  140. #140
    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 - 2016

    Anyone care to wade in on this 1? Weird formatting in cells that cannot be changed (without clearing formats)
    http://www.excelforum.com/excel-gene...formatted.html

  141. #141
    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 - 2016

    I am stumped on this. http://www.excelforum.com/excel-prog...h-a-macro.html

    OP wants to save files opened with a new name each time it is opened without embedding a workbook open event in the file being opened.

  142. #142
    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 - 2016

    This question is above my pay grade: http://www.excelforum.com/excel-prog...t-to-save.html

    OP wants to email an unsaved file. Can this happen? Have sent him to Ron deBruin's web site, but he continues to have issues.

  143. #143
    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 - 2016

    This started out as a string concatenation problem ... path\filenames etc.
    OP wants to access the resulting file's data.
    I am clueless.

    http://www.excelforum.com/showthread...23#post4525023

  144. #144
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Call in the Cavalry - 2016

    OP wants to use "contains" with AND/OR over 6 potential variables to apply filter either
    http://www.excelforum.com/excel-prog...-criteria.html

  145. #145
    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 - 2016

    This one feels mostly like a business calculation question, as the OP is trying to match a IRR/XIRR type calculation performed in another software package and perform the exact same calculation in Excel. Since I do not know enough business math to understand the different variations on IRR/XIRR, I cannot offer any more.

    http://www.excelforum.com/excel-char...ck-charts.html

  146. #146
    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 - 2016

    OP is looking to copy some files and store them on the clipboard via VBA and then select a location to paste them manually Ctl +V. Any takers

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

  147. #147
    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 - 2016

    Anyone care to comment on this 1? OP says their password in a file on their private pc, suddenly was not there any more...
    http://www.excelforum.com/showthread...63#post4548663

  148. #148
    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 - 2016

    Posted in the Call in Cav 2017, but maybe many dont know that thread has been created...
    Anyone want to assist with this one please?
    http://www.excelforum.com/showthread.php?t=1168391

Closed Thread

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 - 2014
    By JBeaucaire in forum The Water Cooler
    Replies: 351
    Last Post: 01-06-2015, 07:56 PM
  5. 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
  6. [SOLVED] Posting a New Thread in "Call in the Cavalry"
    By judgeh59 in forum The Water Cooler
    Replies: 5
    Last Post: 02-19-2014, 12:20 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