+ Reply to Thread
Page 1 of 2 1 2
Results 1 to 200 of 352

Call in the Cavalry - 2014

  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 - 2014

    Any Pivot Table assistance for this OP?

    http://www.excelforum.com/excel-gene...orksheets.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
    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 - 2013 onwards

    OP just want to check whether the time in the cell is not within 2 hours from the current time and want to highlight it with CF. I don't know what I am doing wrong with this thread

    http://www.excelforum.com/excel-form...n-2-hours.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

  3. #3
    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 - 2013 onwards

    Getting on a plane and can't pursue this, should be a simple INDEX/MATCH or INDIRECT....

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

  4. #4
    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 - 2013 onwards

    Poster here may benefit from someone with more tolerance than I: http://www.excelforum.com/excel-char...ml#post3528729
    Thank you.
    • 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

  5. #5
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Call in the Cavalry - 2013 onwards

    anyone knows of any limitation of Named Range when doing 3D referencing for COUNTIF? tried to search for it but couldn't find any related article
    http://www.excelforum.com/excel-form...t-working.html

    this doesn't work:
    =SUM(COUNTIFS(A_Series,B2, B_Series,B3, C_Series,B4))

    but somehow, changing any 1 of the Named Range to the formula works. for eg.:
    =SUM(COUNTIFS(INDIRECT("'"&{"Sheet1";"Sheet2"}&"'!A:A"),B2, B_Series,B3, C_Series,B4))
    or:
    =SUM(COUNTIFS(A_Series,B2, INDIRECT("'"&{"Sheet1";"Sheet2"}&"'!B:B"),B3, C_Series,B4))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

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

    Re: Call in the cavalry -- need help solving this thread

    Can't wrap my head around how to solve this one simply.

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

  7. #7
    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'm not sure what I stepped in here. A lack of coffee might be all that stands in my way. Or it could be a lot worse.


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

    A known Row label, a known Column which repeats; find MIN value for intersection of row and columns.

    Tried mod to min every nth column, even sumproduct. I'm out of my league.


    Edit: Thanks for bailing me out martinwilson
    Last edited by daffodil11; 01-07-2014 at 07:00 PM.

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

    Re: Call in the Cavalry - 2014 onwards

    Would appreciate it if someone can take over here:
    http://www.excelforum.com/excel-form...y-figures.htmlI'm lost..

  9. #9
    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 good at Hyperlinks across a network?

    http://www.excelforum.com/excel-gene...ml#post3536279
    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

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

    "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. #11
    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,811

    Re: Call in the Cavalry - 2014 onwards

    this one is just beyond my knowledge and could use some VBA assistance

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

    Thanks guys
    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

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

    Re: Call in the Cavalry - 2014 onwards

    This should not be too difficult but I'm running out of time.
    http://www.excelforum.com/excel-form...n-a-range.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.

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

    Re: Call in the Cavalry - 2014 onwards


  14. #14
    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,811

    Re: Call in the Cavalry - 2014 onwards

    Changing sheet names with dates. I am at a loss on how to take this to the next step to cure this issue.

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

    Any takers

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

    After opening the file in this thread...
    http://www.excelforum.com/excel-new-...-my-sheet.html

    When I try to set the rows to appear at the top of each sheet, it wont let me in there. Any suggestions??

  16. #16
    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,091

    Re: Call in the Cavalry - 2014 onwards

    Can someone step in here and either back me up or offer an alternative explanation or approach.

    If macro password cracked then kill thisworkbook !

    The OP wants his code to activate and kill the workbook if the VBE is visible ... that is, if someone has removed the VBE Password protection. I've tried to explain that the chances are the code will not be active and so will not kill the workbook.

    Am I just not explaining it very well?

    Thanks, 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


  17. #17
    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,811

    Re: Call in the Cavalry - 2014 onwards

    I cannot provide a viable solution. Appears to be over my skill level. I think it involves a worksheet change event, but I can't get it to work.

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

  18. #18
    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

    You can see from my comments at the end of Post #9 in this thread:

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

    that there is something strange with the cells that appear to be empty in the file that the OP provided in Post #3.

    I eventually solved the problem, but I was wondering if anyone can shed any light on the behaviour of the empty cells for the first material.

    Pete

  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 - 2014 onwards

    Quote Originally Posted by Pete_UK View Post
    something strange with the cells that appear to be empty in the file that the OP provided in Post #3.
    Not sure you are talking about which are of the cells in that file

  20. #20
    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,811

    Re: Call in the Cavalry - 2014 onwards

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

    I have provided the OP with his steps 2-5 as he requested in the early part of the thread. He is now asking for additional actions with the macro. I don't think it is something that can be done, unless it is with a Worksheet Change Event. I'd really appreciate someone else looking at this.

    Alan

  21. #21
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call in the Cavalry - 2014 onwards

    I can figure out a rule that the address formats follow that would allow a clean answer to this post: http://www.excelforum.com/excel-prog...-shortcut.html

    Also I can't figure out how to do the country abbreviations without a lengthy list defining them.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

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

    Re: Call in the Cavalry - 2014 onwards

    For my benefit and the OP's, does someone know how to change the "how should excel treat blanks in charts" options in 2007/2010. I know how to do it 2002/2003, but not in the later versions: http://www.excelforum.com/excel-char...ml#post3552017
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  23. #23
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Call in the Cavalry - 2014 onwards

    Anyone that is able to assist here?

    http://www.excelforum.com/excel-form...-one-cell.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

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

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  24. #24
    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,811

    Re: Call in the Cavalry - 2014 onwards

    I'm stumped on this. Any assistance?

    http://www.excelforum.com/microsoft-...is-denied.html

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

    Even I am also curious to know the solution

    The issue is the Turning off the Screen updating won't worked for the Worsheet Change Events and from my experience which makes the flickering even more.

    Any solution for this issue?

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

  26. #26
    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 suggestion why this can't be able to get the shown result with the help of Pivot Table - Multiple Consolidation Ranges?

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

  27. #27
    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,811

    Re: Call in the Cavalry - 2014 onwards

    Any suggestion on how to solve for the nine most current weeks.

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

    I cannot think of a viable means to calculate given the current parameters. OP changes week numbers at beginning of year and throws off my calculation and I cannot think of an alternative.

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

    Re: VBA

    Some VBA needed here. Looks simple but having a mental block.

    http://www.excelforum.com/excel-form...-for-this.html

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

    This has exceeded my skill level.

    For each match of A, provide B, C, D when E is not the MIN of the group of A and is different than the row with the MIN value.

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

    Edit: solved with brute force
    Last edited by daffodil11; 01-31-2014 at 05:22 PM.
    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!

  30. #30
    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 use a laptop (I cant stand them lol), that may offer some insight here?
    http://www.excelforum.com/excel-gene...ml#post3568932

  31. #31
    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 not convinced in my suggestion and waiting for the second opinion here...

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

  32. #32
    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 suggestions on this one?

    I thought to go for Multiple Consolidation Ranges option of PT but not the right choice

    http://www.excelforum.com/excel-gene...g-vlookup.html

  33. #33
    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 understand the OP's requirement but I completely lost here...

    http://www.excelforum.com/excel-prog...eets1-2-a.html

  34. #34
    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 suggestions why the comment box is showing as normal textbox in a specific file alone?

    http://www.excelforum.com/excel-gene...ing-issue.html

  35. #35
    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 any suggestions here?
    http://www.excelforum.com/excel-gene...ml#post3578328
    OP cam upload a file, but when they download and open that same file, they get a message that the file is corrupted

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

    Re: Call in the Cavalry - 2014 onwards

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

    This one is probably more statistics than Excel, but does anyone have anything more concrete to offer regarding how statisticians would approach this kind of problem?

  37. #37
    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,811

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-gene...-text-box.html

    OP is looking to add comments to a TEXTBOX similar to comments for a cell. She wants to add a photo to the comment. Is this an option. My only thought is to have a msgbox pop up when the Textbox has focus. Is there an easier way? Can you help her?

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

    I fear I may be getting tired and missing something, here...

    http://www.excelforum.com/excel-prog...copy-past.html

    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...

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

    In the below link please refer Post # 7 alone, in which I explained the problem with Example file.

    The Picture is not loading on Drop down selection when the file opened in Excel 2003 version

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

  40. #40
    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 provided my level best answer to OP and OP not seems to be happy with the provided solution.

    If anyone is interested then please help the OP

    http://www.excelforum.com/excel-gene...-on-cells.html

  41. #41
    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

    In the below link OP is claiming that the Sheet Reference of the source workbook is getting deleted in formula bar when he opens the source workbook.

    I am unable to fix it and any suggestion will be very much helpful

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

  42. #42
    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

    i am lost in the logic of this one probably simple but i'm now going round in circles!
    http://www.excelforum.com/excel-form...o-numbers.html

  43. #43
    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,811

    Re: Call in the Cavalry - 2014 onwards

    This one now goes beyond my skill level. http://www.excelforum.com/excel-prog...workbooks.html

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

    Afraid I'm not at all sure what the OP means.

    http://www.excelforum.com/excel-prog...ease-help.html

    Cheers
    Click * below if this answer helped

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

  45. #45
    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 have any suggestions here?

    http://www.excelforum.com/excel-gene...rdly-slow.html

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

    Can someone help this OP - I have neither the time nor the patience today

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


    Update** I think it's now solved - all my plans fell through for that day
    Last edited by xladept; 02-22-2014 at 04:05 PM.
    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

  47. #47
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Call in the Cavalry - 2014 onwards

    Wrt:
    http://www.excelforum.com/excel-prog...uplicates.html

    The code below creates a DEFINED NAME: "genii" and several smaller named lists dependent on it. I cannot use those names in Data Validation references. Why?
    Please Login or Register  to view this content.
    I can, however use VBA to create the Data Validation Lists directly:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Ben Van Johnson

  48. #48
    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,091

    Re: Call in the Cavalry - 2014 onwards

    Because the Data Validation List has to be text strings or a contiguous range. GenusList is an array.

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

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

    long thread sorry...

    I have tried a variety of things and the biggest problem is that it fine on my excel but when he runs it on his actually data he gets a type mismatch error (13).

    Any help would be great...thanks....
    Ernest

    Please consider adding a * if I helped

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

  50. #50
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Call in the Cavalry - 2014 onwards

    Could someone please help this OP?

    http://www.excelforum.com/excel-form...ort-order.html

    It looks like there is a need for vba solution.

    Thank you.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

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

    Any suggestion here

    OP is trying to "array enter" a formula in a range of cells and seems to be following the correct process but it doesn't work
    Audere est facere

  52. #52
    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

    my patience is going ...going ....gone here,someone has obviously been "jerking this blokes chain" but op seems to have no idea about excel, any one with the patience of a saint want to carry on?
    http://www.excelforum.com/excel-new-...ndom-sort.html

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

    Re: Call in the Cavalry - 2014 onwards

    @martin

    That guy has to be a troll.

  54. #54
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Martin: you cannot be serious (in a loud voice with a John McEnroe accent)

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

    @Martin - I told him/her to just do it

  56. #56
    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,811

    Re: Call in the Cavalry - 2014 onwards

    Hopefully someone with experience in hyperlinks in VBA can step in and help the OP finish up this project.

    http://www.excelforum.com/excel-prog...folders-2.html

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

    Re: Call in the Cavalry - 2014 onwards

    Is there anyone has experience in SUBTOTAL function? The OP in this thread

    http://www.excelforum.com/excel-form...-and-team.html

    needs to sum hours and count persons in giving team, task and shift. Fdibbin did the sum and I did the count. The issue is SOLVED, but

    I am quite not satisfied with the result.

    I used SUBTOTAL(9,OFFSET...) to count rows with values >0 in row. Results in sheet Template are correct. But if the column of task# in

    sheet Data would be activated, i.e for task 1, the result of task 2,3,4...would return 0.

    I tried SUBTOTAL(109,...) for hidden counting, but thing did not change.

    I am so confused now with SUBTOTAL in complex cobination with OFFSET, MATCH,...

    Thanks in advance and willing to learn from you.
    Quang PT

  58. #58
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Call in the Cavalry - 2014 onwards

    I offered this VBA solution to the OP's problem of adding successive randomly generated numbers:
    Please Login or Register  to view this content.
    The weird thing is that when I close the workbook without saving, then re-open it, it generates the SAME numbers each time, when they should be random.. shouldn't they?

    Hopefully someone can see the error of my ways? (Even though it does do what the OP wants, I am concerned that a duplicating sequence of numbers would not be helpful).

    - Moo

  59. #59
    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,091

    Re: Call in the Cavalry - 2014 onwards

    I don't often use Rnd but, reading the help:

    Rnd[(number)]

    The optional number argument is a Single or any valid numeric expression.

    Return Values

    If number is: Rnd generates
    Less than zero: The same number every time, using number as the seed.
    Greater than zero: The next random number in the sequence.
    Equal to zero: The most recently generated number.
    Not supplied: The next random number in the sequence.

    You're not supplying a number so I guess it remembers what it last used somehow ... so you get the next number in sequence.

    Regards, TMS

  60. #60
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Call in the Cavalry - 2014 onwards

    Thanks for that explanation TMS. Is there a better way to generate a random number with VBA? Since this method is clearly not anything close to random... not even 'pseudo-random' if there is an actual sequence.. lol

    - Moo

  61. #61
    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 Moo,

    You could use Rnd(Timer)

  62. #62
    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,091

    Re: Call in the Cavalry - 2014 onwards

    To be honest, I can't offer that much help. if you Google: excel vba generate unique random numbers, you may find something of interest though one of the responses I saw indicated that the cycle could be quite short and then repeat exactly the same numbers.

    Regards, TMS

  63. #63
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @xladept: ooohhhh ... good thought.

    Just out of interest, you could change the code to the following to see the sequence of numbers generated

    Please Login or Register  to view this content.

    Regards, TMS

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

    you have to use randomize i think


    Please Login or Register  to view this content.

  65. #65
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Call in the Cavalry - 2014 onwards

    Thank you TM, XLA and Martin... you are all so very helpful. =)

    - Moo

  66. #66
    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're welcome! And, thanks for the rep!

  67. #67
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Moo: ditto. Although ...
    always quite helpful

  68. #68
    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 is using importxml in google docs ,im pretty sure there is no native equivalent in excel 2013
    but i dont know enough about it ,could it be done with code/udf
    http://www.excelforum.com/excel-form...el-2013-a.html

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

    In this Thread, the Code adds new Rows by Button Click. It copies Data from above, including Conditional Formatting.

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

    I don't know why the Conditional Formatting is not being applied...the Formulas appear to be in place but aren't firing. Anybody help?
    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.

  70. #70
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call in the Cavalry - 2014 onwards

    I need some suggestions here: http://www.excelforum.com/excel-prog...-workbook.html

    I don't know of a way to check for protection without opening the document.

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

    I know some have visited this poster's issue. I stoped by to see if I could help him to better define his needs and I'm still not sure though he has gotten closer. He is private mailing me to ask for help. I'm going to throw this link out here to see if anyone wants to look at his issue and see if they can help.
    http://www.excelforum.com/excel-gene...ows-plz-2.html

    Thanks.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

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

    Re: Call in the Cavalry - 2014 onwards

    Does anyone has 2003 version can help with condition formating:

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

    I am using 2007 and could not remember CF in 2003.

    Thanks

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

    In this thread OP is looking for Array solution but for me I don't see any need for Array Formula.

    Seems to be a assignment question for my eyes....

    http://www.excelforum.com/excel-gene...t-working.html

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

    In the below thread the OP unable to rename/delete the worksheet in any of his Excel Workbook.

    Any suggestion will be highly helpful

    http://www.excelforum.com/excel-gene...cel-forum.html

  75. #75
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Canada Eh
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Call in the Cavalry - 2014 onwards

    I don't have the time to code these requirements. Maybe one of you can offer a better solution to the ones that I suggested.
    Click the * to give Rep to a post you like.

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

    Re: Call in the Cavalry - 2014 onwards

    Feel free to jump in on this one.

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

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

    I think I'm suffering from "It's Friday and it's been a long week"!

    Anyone feel like picking up the patient stick on this one: http://www.excelforum.com/excel-form...rd-column.html

    I've already declined the OPs kind suggestion by PM that he can Skype me for me to fix for him...

  78. #78
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Olly: I don't think so. It's still Friday afternoon this side of the hills.

    Regards, TMS

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

    VBA, Worksheet Change:

    When values are added to Sheet1 Column A, also insert hyperlink on Sheet2 Column B that link back to Sheet1's cell.

    I've been teetering on the edge of victory for 24 hours, but I just can't quite debug it.

    I've tried both manual and formula methods, but hitting brick walls.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    https://www.excelforum.com/showthread.php?t=994673

  80. #80
    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 someone see if they can make any sense out of this 1? Im about as confused as a chamelion in a box of M&M's (or smarties)

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

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

    This should be obvious, but can't say I'm a 100% sure that Excel doesn't have to calculate the SUM on the range beyond the "last-used" cell?

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

    So they're right that simply setting the SUM range to the entire column would be more efficient in this case?

    Cheers

  82. #82
    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

    anyone seen this screen shot here and recognise what's being used?
    http://www.excelforum.com/excel-gene...his-excel.html

  83. #83
    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

    http://www.excelforum.com/excel-gene...nto-excel.html
    simple web queries i can do but this is beyond me anyone know how to do this?

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

    Re: Call in the Cavalry - 2014 onwards

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

    I don't have a clue how to even begin on this one.

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

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by alansidman View Post
    http://www.excelforum.com/excel-prog...-criteria.html

    I don't have a clue how to even begin on this one.
    Look like to establish list of IDs in C column which corresponds to "yes" in D column.

    I try with formular to display the expected results in order to help other helpers to put it an end with macro:

    In B23:

    =IFERROR(INDEX($C$1:$C$14,SMALL(IF($D$2:$D$14="yes",ROW($D$2:$D$14),""),ROW(A22))),B15)

    Confirmed with Ctrl-shift-enter

    Copy up.

    Can anyone give help with macro?

  86. #86
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call in the Cavalry - 2014 onwards

    I'm not that good with formulas. I think formulas might be able to take care of this OP better than looping through two worksheets umpteen times.

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

  87. #87
    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 really can't understand what is the exact problem is?

    The below thread is about External Link to other files, anyone have time then please pitch in here... Since I am not interested to continue with this thread

    http://www.excelforum.com/excel-gene...et-rid-of.html

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


  89. #89
    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

    For me, it's seems like a real formula challenge Unable to do it in single cell formula, I am lost here....

    OP looking for any solution to arrive the expected result (UDF / Formula), but I am not interested to go for UDF since I am 100% sure some of you can achieve it in single cell formula with the inbuilt excel functions.

    Any suggestion will be highly helpful to the OP.

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

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

    Re: Call in the Cavalry - 2014 onwards

    Anyone able to help on this one? I'm beyond lost.
    http://www.excelforum.com/excel-form...0-targets.html

  91. #91
    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

    can someone look what this macro should do: http://www.excelforum.com/excel-prog...nd-msgbox.html

  92. #92
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Call in the Cavalry - 2014 onwards

    Anyone know how to convert Excel 2013 functions to 2010 or earlier?

    http://www.excelforum.com/excel-form...el-2010-a.html

    I suggested an add-in available on the web, but OP isn't interested in that...

    - Moo

  93. #93
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Call in the Cavalry - 2014 onwards


  94. #94
    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

    wanted to draw some other looks at this thread:

    http://www.excelforum.com/excel-form...d-updated.html

    Down to post #5 where he seems to simplify things a little, thanks.

  95. #95
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call in the Cavalry - 2014 onwards

    Need some help here. http://www.excelforum.com/excel-prog...duplicate.html

    I think I've coded what he needs to sheet copy but OP has extra class modules they want to get rid of and the Remove option is greyed out.

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

    http://www.excelforum.com/excel-prog...-13-error.html


    This is a weird LotusNotes to Email problem....

  97. #97
    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 any ideas on this 1? OP says the "split-screen" buttons are not there...
    http://www.excelforum.com/excel-gene...ml#post3632487

  98. #98
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Call in the Cavalry - 2014 onwards

    can someone look at this:
    http://www.excelforum.com/excel-form...le-values.html

    I think the op need a macro
    Click (*) if you received helpful response.

    Regards,
    David

  99. #99
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Call in the Cavalry - 2014 onwards

    Another OP that need macro

    From my point of view:
    1. The OP want hide the sheet with password so anyone can't freely see all the sheet.
    2. The OP want if the workbook save on other computer, so the user only see the sheet that the OP allow to see, base on username on the system.

    http://www.excelforum.com/excel-form...user-name.html

  100. #100
    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 have any suggestions onthis 1?

    OP has a sumproduct() with month() inside it, but when we try to change that to weeknum() it errors....
    http://www.excelforum.com/excel-form...ml#post3634899

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

    Re: Call in the Cavalry - 2014 onwards

    15 posts without any help!
    In fact, I am really really ready to give help, but I dont have much time for such complicated technical issues at the moment. Is there anybody wanna to jumb in and give a start?
    http://www.excelforum.com/excel-form...ml#post3635500

  102. #102
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call in the Cavalry - 2014 onwards


  103. #103
    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

    I have no idea why this is returning an error for the OP. I've tested on three different machines now - download his workbook (original data.xlsx), paste in my code, and it runs perfectly for me every time, in 2010 and 2013.

    Anyone able to test for me, see if I'm missing something obvious?

    http://www.excelforum.com/excel-prog...aste-loop.html

  104. #104
    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,091

    Re: Call in the Cavalry - 2014 onwards

    Can someone have a look at this one. Run out of steam and I'm going to be away for a few days.

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


    Thanks, TMS

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

    Re: Call in the Cavalry - 2014 onwards

    I leave this to sharper minds than mine.

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

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

    Quote Originally Posted by ChemistB View Post
    I leave this to sharper minds than mine.

    http://www.excelforum.com/excel-form...-criteria.html
    I downloaded the file earlier this morning.

    As soon as I opened it I closed it and deleted it off of my hd!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

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

    Re: Call in the Cavalry - 2014 onwards

    As soon as I opened it I closed it and deleted it off of my hd!
    LOL, made me chuckle, Tony

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

    Re: Call in the Cavalry - 2014 onwards

    Quote Originally Posted by ChemistB View Post
    I leave this to sharper minds than mine.
    Open-Close-reopen-close and:
    I wish my mind would sharper than you.
    Good luck, Chemist B

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

    Anyone know if this is a known bug?

    http://www.excelforum.com/excel-form...-an-array.html

    See post #9 only - does everyone else's machine crash/run of out resources when attempting this one simple formula?

    Cheers

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

    Lots of new and interesting features/bugs unearthed today!

    Anyone know why SUMIF converts the text to a numeric in this case? And is there a way to stop that conversion (and still use SUMIF)?

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

    Cheers

  111. #111
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call in the Cavalry - 2014 onwards

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

    OP is talking to himself. Can anyone assist?

  112. #112
    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 please join in the below thread, since I can't able to understand the OP's requirement

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

  113. #113
    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 idea about how to close the Print Preview modal window in VBA?

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

  114. #114
    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

    I think code will stop when this window is shown. It is easier to let user press Print or Cancel.

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

    Yes, the code is interrupting and waits to run the rest of the codes when the window close.

    But even sendkeys doesn't seem to work at my end with application.ontime timevalue("00:00:05")

    I thought to close the workbook by using esc as send key and get the user input via msgbox and based on the user selection (Yes/No) we can continue or exit the code. But it's not working as expected

  116. #116
    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

    It's a mad thought, because when the code doesn't run while the Print Preview is active, then how the Send Keys will run Laughing myself

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

    Yes - all code will stop. Why not leave the user to print or cancel, then code may continue?

  118. #118
    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 Izandol View Post
    Why not leave the user to print or cancel, then code may continue?
    Just wondering why Microsoft doesn't kept any solution for this one? The reason for marking the Form Layout as Model explicitly without any way to close it with a powerful tool VBA

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

    I think you must ask Microsoft.

  120. #120
    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 Izandol View Post
    I think you must ask Microsoft.
    lol

    I hope any of the MVP's who reads this post will help us to find the solution for this, since they have access to ask Microsoft directly

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

    Re: Call in the Cavalry - 2014 onwards

    I believe that printpreview will fire the beforeprint event macro - so maybe there is a solution involving code in there, so when the printpreview is fired, the beforeprint code runs, checks whether it should be printing or showing printpreview and then gives you the yes/no message box.

    Edit - just tried and that doesn't work, the code runs before the print preview window is shown.
    Last edited by ragulduy; 03-31-2014 at 08:23 AM.

  122. #122
    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 what he's asking? http://www.excelforum.com/excel-prog...nd-column.html

    I don't even know what data is in what sheet.

  123. #123
    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 with a bit of code for cleaning up unwanted characters?

    Never come across this ASCII before.

    http://www.excelforum.com/excel-form...er-format.html

    Cheers

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

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-form...ml#post3645444
    This guy seems rather intent on speeding up his formulas. I offered my suggestions (all around the idea of trying to help Excel reduce the number of operations needed), but he doesn't feel helped for one reason or another. I'm not very good with Pivot tables or other database type functions. It is beginning to look to me like there is not going to be a simple tweak to the formulas that will dramatically speed up the calculation. Anyone with more database management type experience that could suggest some ideas for better managing the database? I'm wondering if this could be better accomplished using a completely different set of database tools in Excel, or even a dedicated database application rather than a spreadsheet. I don't do database type work so I really don't know.

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

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-form...ml#post3652083
    User in my local excel forum needs to sum hours per shift during given dates.
    Seems I am in stuck and need your advice.
    Is there anyone ready to deal?

  126. #126
    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

    Does anyone have Mac version of excel?

    If so, then please join in the below thread and suggest how to change Post 9 formula needs to be converted to Mac excel functions...

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

  127. #127
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Sixthsense: It's not a Mac version of Excel. Documents To Go is an Android App which allegedly can create and edit Office compatible documents.

    Regards, TMS

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

    Hi TMS,

    Thanks for correcting me , I misinterpreted it with Mac since I never seen Mac till now

    As I remember, 3 to 4 years back there was a question posted in MS-Old News group in that the OP asked for an alternative method for ROUNDUP / ROUNDDOWN since in his Windows Mobile which have only ROUND() alone. I think this thread similar like that one

  129. #129
    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,091

    Re: Call in the Cavalry - 2014 onwards

    No problem. I think, in the old days, for ROUNDUP and ROUNDDOWN, you would have added or subtracted 0.5 (or .05, .005, etc) before using ROUND.

    Regards, TMS

  130. #130
    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 TMS View Post
    you would have added or subtracted 0.5
    Yes, exactly

  131. #131
    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 have some insight on how this OP might get his results on a combinational sums of 360 numbers FASTER in this thread?

  132. #132
    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 able to pick up on this one:http://www.excelforum.com/excel-prog...-computer.html

    Interesting migration of some OLD code controlling COM ports, and although I'm enjoying trying to unpick it, it's 2:30am and I need my bed!

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

    Re: Call in the Cavalry - 2014 onwards

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

    Anyone able to help on this one with some VBA? It's much more complicated in 2003 and I'm unable to test any code I write using the simpler .displayformat property.

  134. #134
    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 someone see what he's looking for? http://www.excelforum.com/excel-prog...using-vba.html

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

    Re: Call in the Cavalry - 2014 onwards

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

    Anyone able to help here - I've not tried this sort of thing before but the followhyperlink event doesn't seem to be picking up the correct target. Is there a fix/another method?

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

    Any mod/guru up for a challenge (or just want to drive yourself nuts?) OP here has a circ ref in a mess of formulas over 3 sheets...
    http://www.excelforum.com/commercial...ml#post3658194
    (Good luck, I am often fairly good with circ's, but I will leave this 1 to some1 else)

    When you "fix" the formula and copy it down a few rows, there is no CR, but after a few more rows it kickes in

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

    Re: Call in the Cavalry - 2014 onwards


  138. #138
    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

    Anyone want to take a stab at this one? It's a complicated ranking scheme.

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

  139. #139
    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,091

    Re: Call in the Cavalry - 2014 onwards

    Anyone care to have a look at this ...

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

    What it says on the tin. One specific Excel file crashes when saved either using code or manually. Can be replicated on a brand new machine so it points to the file rather than the environment.

    Thank, TMS

  140. #140
    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 please join in the below thread, since I offered my better coding and I am completely unable to understand what is his original requirement

    Also OP claiming something which won't happen in that way since the code is sticked for certain columns and don't know what's going wrong on OP's side

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

  141. #141
    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 - 2014 onwards

    Does anybody have some canned code to create a text file for each row of data on a sheet?

    http://www.excelforum.com/excel-prog...text-file.html

    seems to want this function and I really think it is a step backwards.

    I'm disowning the question, as I work for free and think any answer like the OP desires isn't going to help much.
    (I give rep for helpers.)
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  142. #142
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @MarvinP: i have provided a basic macro to write a text file for each cell in column A. They are simply named URL x.txt.

    No idea how the OP would like them named but the index is used to make them unique. If a file exists, it will be overwritten.

    Regards, TMS

  143. #143
    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,811

    Re: Call in the Cavalry - 2014 onwards

    This is a bit out of my wheel house. An interesting question

    http://www.excelforum.com/excel-prog...-by-dates.html

  144. #144
    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

    Can anyone give this person some help?
    http://www.excelforum.com/excel-form...-in-other.html
    It may be a simple solution but I can't get my head around it as I've tried different versions of substitute and left and mid while adding -- to it but with no success.
    I think it may require VBA. I'll be interested in seeing what someone comes up with.

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


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

    An interesting use of the FollowHyperlink event:
    http://www.excelforum.com/excel-prog...ks-in-vba.html

    Any suggestions?

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

    Re: Call in the Cavalry - 2014 onwards

    Anyone got an idea with a formula for this:
    http://www.excelforum.com/excel-form...er-groups.html

  148. #148
    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,811

    Re: Call in the Cavalry - 2014 onwards

    I've hit a snag here with some VBA and don't see the issue causing nothing to be copied.

    Your thoughts http://www.excelforum.com/excel-prog...le-sheets.html

  149. #149
    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 don't know how better I can explain the OP than this anyone please jump in and save me

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

  150. #150
    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,811

    Re: Call in the Cavalry - 2014 onwards

    Anyone have any experience using the Excel Forecast Function. It took me several postings to realize what the OP was after and then realized that I have no idea how to help as I have never worked with the Forecast Function. If you have some experience here or an understanding, then please jump in and help.

    http://www.excelforum.com/excel-gene...le-sheets.html

  151. #151
    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 worked with Office 365 and know of any sorting restrictions beyond a certain number of rows>

    http://www.excelforum.com/office-365...ml#post3683289

  152. #152
    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

    OK I been banging my head on this 1 for too long, need a fresh pair of eyes....
    http://www.excelforum.com/excel-form...lain-this.html

    Column H always displays the first result in G until we get the first result in F and vice versa. Does this answer the question? The previous suggestions were super, super close with just a few glitches. Does this help?

  153. #153
    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

    Trying to copy only visible cells, my normal suggestions aren't working for this thread:

  154. #154
    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

    Please anyone join in the below thread who knows about setting the ADODB.Connection in VBA, A small adjustment needs to be done in the OP's coding but I am unable to fix it, since it is out of my expertization

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

  155. #155
    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 am really confused about what he is looking for (VBA)

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

  156. #156
    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

    In my test workbook, these lines of code are working to filter uniques values from a single column directly into an array:
    Please Login or Register  to view this content.
    The OP in this thread is using the exact same code in the workbook provided in the thread and this is not working. I know other ways to do this, I'm specifically wondering if anyone can spot why this method is not working on this workbook?

    Any feedback would be appreciated.

  157. #157
    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

    Anyone want to see if they can understand what this OP wants:

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

    I don't understand what they're trying to do.

  158. #158
    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,811

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-new-...ate-cells.html

    OP has an issue in trying to get into VBE. I have offered my solutions, Alt + F11 and Through Developer Tab on the Ribbon. It appears that the Developer Tab is greyed out and Alt + F11 does not do the trick for her. Is this something her IT dept may have done or is there a switch within Excel that may have been turned off. If you have seen this before and can assist, then please jump in. Thanks.


    Edit: Just found this link and provided to OP. Don't know if this is the issue however.

    http://www.excelforum.com/excel-prog...-disabled.html
    Last edited by alansidman; 05-07-2014 at 04:51 PM.

  159. #159
    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

    Inserting columns in newer versions of Excel takes noticeably longer than it did in Excel 2003. The OP in this thread is looking for ideas on speeding up his short macro. He's only inserting about 10 empty columns, but it's taking 10 minutes to accomplish. I've given my thoughts, any others are welcome to add to the mix.

  160. #160
    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 would say deleting rows/columns too.

  161. #161
    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 given a Non VBA solution but the OP looking for VBA solution only, Any one please jump in this thread

    http://www.excelforum.com/excel-prog...ell-value.html

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

    Re: Call in the Cavalry - 2014 onwards

    Going beyond my limited VBA skills

    http://www.excelforum.com/excel-form...n-changes.html

  163. #163
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Call in the Cavalry - 2014 onwards

    Anyone that can helps our friend here? I am not able to understand the logic.

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

  164. #164
    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 got the logic but can't get formula
    Last edited by zbor; 05-15-2014 at 07:57 AM.

  165. #165
    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,811

    Re: Call in the Cavalry - 2014 onwards

    I'm not sure if its me or the OP. If you think you know what this guy is up to, then please jump in. Automatic Sorting is the key.

    http://www.excelforum.com/excel-prog...d-on-date.html

  166. #166
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Alan: sorry, not barge pole long enough

  167. #167
    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,811

    Re: Call in the Cavalry - 2014 onwards

    @Trevor; In that case, can you throw me a life line, because I am sinking here.

  168. #168
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Alan: I would love to but having looked at the example file, I have no idea what it needs doing to it. Sorry

  169. #169
    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,811

    Re: Call in the Cavalry - 2014 onwards

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

    I have provided a working solution for the OP for an onClose event, but he is looking for an instantaneous change. I tried a similar solution for the Workbook_Sheet Change Event and the Worksheet Change Event (putting the VBA in all three sheets for the worksheet change event).

    In all cases, the VBA just hangs. If I stop the VBA from running, it has updated the cells A1 and B1. If you have a solution for this, then please offer it up. For the record, here is what I tried in the worksheet change event for each of the sheets. Did I miss something to make it hang???

    Please Login or Register  to view this content.
    Last edited by alansidman; 05-18-2014 at 06:56 AM.

  170. #170
    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,091

    Re: Call in the Cavalry - 2014 onwards

    You're making changes in a change event handler so I suspect it is looping ... maybe compounded by making the changes to several sheets. Use Application.EnableEvents = False before changes and = True after.

    That would be my first suggestion anyway.


    Regards, TMS

  171. #171
    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'm adding my own thread because nobody in the regular area answered.....

    CLick Here

  172. #172
    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 can tell now the reason you got no answers is because you bumped your own thread almost immediately. People are looking for new posts with zero replies to jump into, you killed that almost immediately. TIP of the day, EDIT your original post until others start to reply, then add new responses. Bumping really does work against you, accidentally.

  173. #173
    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 figured that and really the first "bump" was me adding the link....and I thought I was editing the OP but apparently not....thanks JB....so any ideas on the actual problem....

    on a side note: I consider myself a pilot because I fly aerobatic RC's. I have PItt's Special....

  174. #174
    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

    No, I won't be joining in, but I did merge your posts back into one so your thread will appear on the Unanswered Posts listing.

  175. #175
    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

    thank you Sir

  176. #176
    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,811

    Re: Call in the Cavalry - 2014 onwards

    Here is an interesting problem for the OP. It is beyond my capabilities.

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

  177. #177
    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,811

    Re: Call in the Cavalry - 2014 onwards

    OP has changed requirements and I cannot wrap my head around a starting point on this one.

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

  178. #178
    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,

    Formulas are just one of my weaknesses - can one of you formula savvy contributors fix this thread?

  179. #179
    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 someone pitch in on this 1 please? OP wants to pull max value from various workbooks...
    http://www.excelforum.com/excel-gene...ml#post3708686

  180. #180
    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,091

    Re: Call in the Cavalry - 2014 onwards

    Anyone have a go at this:

    http://www.excelforum.com/excel-prog...und-color.html

    The OP wants to be able to "highlight" a selected cell on any worksheet by setting Target.EntireRow and Target.EntireColumn interior color as a "cross hairs" effect. The problem is that, when he selects another cell, it clears any previous color formatting.

    I've done some testing, despite not having a sample workbook , and I can't think of a way to protect the pre-existing formatting.

    Thanks, TMS

  181. #181
    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

    Hi TMS,

    CF is the method needs to be used

    Adding CF and Deleting CF will override the cell formatting and it will not clears the original font color/interior color of cells.

  182. #182
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @SS: thanks, good thinking.

    An example is shown here:

    http://www.tushar-mehta.com/publish_...d%20cell.shtml


    Regards, TMS

  183. #183
    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 TMS View Post
    @SS: thanks, good thinking.
    Glad to know that there was a solution already made with an example .

    Thanks a lot for sharing the link and rep also.

    I will preserve that link for future use for redirecting the OP, if anyone come with the same type of question

  184. #184
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @SS: you're welcome. I just Googled it and there were other results but this one seemed to explain it well and came with an example workbook. Lots of different methods demonstrated. Thanks for the feedback

  185. #185
    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 don't know how further I can help this OP

    Will be helpful if anyone join in this thread and offer a suggestion (VBA)

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

  186. #186
    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

    Sometimes I feel like I step in puddles that have oceans hidden under them.

    OP needs to encapsulate existing code in a loop that cycles through all worksheets.

    A simple For Each ws / Next loop didn't quite work. I think something in existing code is stopping it.

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

  187. #187
    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,811

    Re: Call in the Cavalry - 2014 onwards

    Sometimes I feel like I step in puddles that have oceans hidden under them.
    What a great line. I sometimes feel that way, also.

    Anyway, here is the current predicament. I don't see a simplistic solution for this OP. If you have one, jump in as the ocean is deep enough to accommodate one more.

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

  188. #188
    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,091

    Re: Call in the Cavalry - 2014 onwards

    @Alan: code provided in the thread.


    Regards, TMS

  189. #189
    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

    Need another set of eyes to look at this 1 please?

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

    The formula works perfectly, except for a handful of names. I am using OFFSET(*) to get the month column - when I use that, a few names throw an error, when I use the actual column ref, it works. The OFFSET() does not use a name, so that cant be it - I have tested all the data in the column, it is all numbers. Cant find the problem

  190. #190
    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 saying that when he uses the below line in his code then his excel is crashing...

    Please Login or Register  to view this content.
    I suggested to turn off the events and try like this...

    Please Login or Register  to view this content.
    But that is also not working for the OP and still the OP is facing the crashing issue

    Any suggestion will be highly helpful to the OP

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

  191. #191
    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


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

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-form...down-list.html

    Good clear title says everything.

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

    Re: Call in the Cavalry - 2014 onwards

    I don't think this OP is going to accept my suggestion to use a helper range. Someone who is good at putting together single cell array formulas can help us make this a single cell LINEST() function? http://www.excelforum.com/excel-form...-possible.html

  194. #194
    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

    Need someone that's good at setting up pivot tables here:

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

    oeldere ?

  195. #195
    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,091

    Re: Call in the Cavalry - 2014 onwards

    Anyone pick this up?

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


    I provided some code that worked when I tested it with the sample files but the OP couldn't get it to work. She's downloaded an alternative solution that she also can't get to work.

    I'm going on holiday in the morning so I can't spend time debugging it.

    Thanks, TMS

  196. #196
    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

    Got a strange 1 here - anyone got any ideas?

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

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

    Re: Call in the Cavalry - 2014 onwards

    http://www.excelforum.com/excel-prog...ell-edits.html

    Anyone with 2013 fancy taking a look at that one.

  198. #198
    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

    Data validation problem.

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

    It works as expected in Excel 2002 but does not work in Excel 2007+.

    I'm baffled!

  199. #199
    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 MAC users that can offer some VBA comment on converting the code in this thread to work on a MAC?

  200. #200
    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 thread posits an interesting problem I've no solution for, and I'm interested If anyone else has an idea? A VBA event method to watch how sheets are named and make sure new sheets are named as dates in a specific format.

+ Reply to Thread
Page 1 of 2 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